meta user
network profile
| bio | website | naya-tech.co.il |
|---|---|---|
| location | Israel | |
| age | 32 | |
| visits | member for | 8 months |
| seen | 3 hours ago | |
| stats | profile views | 20 |
- DBA SQL Server Since June 2011
- Camera: Canon 60D
- Lenses: EFS 17-55 F2.8 IS USM, EF 50mm F1.4 USM
|
10h |
comment |
Re enable Windows Authetication in SQL Server @AkhilKNambiar There is one more option that I can think of. After querying sys.server_principals joined with sys.server_role_members I realized that there are 2 more sysadmins in my server: the accounts used by the services MSSQLSERVER and SQLSERVERAGENT. You can use services.msc or the configuration manager to find what user name your services are using, and then find a way to impersonate them. |
|
14h |
awarded | Autobiographer |
|
1d |
awarded | Critic |
|
May 16 |
comment |
Fixed length text file insert into SQL table @JeffV Please add a few more lines to your data example and the structure of your destination table. I will try to create a sample FORMAT FILE for You. |
|
May 16 |
comment |
Fixed length text file insert into SQL table @SQLFox I will search for the sources that helped me do it, it was a long time ago... I can also write an example for Jeff, I just need a few more lines in his example, and the structure of his destination table. |
|
May 16 |
comment |
Fixed length text file insert into SQL table Using substring() to split millions of rows is a performance disaster. Take a look at my answer using FORMAT FILE, isn't it a better solution for his situation? |
|
May 16 |
comment |
Fixed length text file insert into SQL table MS-Access uses a row-by-row method when working with SQL Server. For 100's of files with 1000's or more lines that will be devestating. |
|
May 15 |
answered | Fixed length text file insert into SQL table |
|
May 15 |
awarded | Caucus |
|
May 12 |
revised |
Disk space full but logical space available in database corrected spelling and added tag |
|
May 12 |
suggested | suggested edit on Disk space full but logical space available in database |
|
May 12 |
answered | Disk space full but logical space available in database |
|
May 7 |
comment |
Is there a difference in performance between @date and getdate()? @MartinSmith Thanks for the remark. runtime constant exists in the scope of a single query, but if the same code has several queries then GETDATE will be called several times. however, it will probably not cost more then constant scan of the variable (same amount of times). as for their use - We can't be sure without their entire server :) I will not change my answer because the bottom line remains the same... |
|
May 7 |
comment |
How do I refresh SQL server cross database references after a database is reattached with a different name? (Are there hidden synonyms?) Please add some basic explanation why this happens, and maybe a link to an elaborated article for reference. that way your answer will be of use for many others in the future who will search for the same thing. |
|
May 7 |
answered | Is there a difference in performance between @date and getdate()? |
|
May 7 |
revised |
Cannot rebuild index, but there's no reason why not? added 28 characters in body |
|
May 7 |
revised |
Cannot rebuild index, but there's no reason why not? deleted 9 characters in body |
|
May 7 |
answered | Cannot rebuild index, but there's no reason why not? |
|
May 6 |
awarded | Organizer |
|
May 6 |
revised |
Why disabling a clustered index makes the table inaccessible? Improved formatting, added Tag, made question clearer |
