Viewing 15 posts - 5,956 through 5,970 (of 49,571 total)
You don't need profiler. Turn traceflag 1222 on and you'll get a deadlock graph written to the error log.
May 13, 2015 at 5:16 am
kanuto.tapon (5/13/2015)
The 2008 database will be updated everyday so what will happen is that there's a scheduled task that will run a certain SSIS/package to copy/backup it to sql 2000.
You...
May 13, 2015 at 2:58 am
Grant Fritchey (5/13/2015)
Otherwise, you can look to set up mirroring to the 2000 system. That won't be perfect, but can work.
Database mirroring?
May 13, 2015 at 2:55 am
colin Robinson-345240 (5/12/2015)
May 12, 2015 at 7:33 am
Lowell (5/12/2015)
i tried putting together an example, but i keep getting a table scan, maybe becaus emy sample table is small.does this look right to everyone?
Yup.
With a tiny table and...
May 12, 2015 at 6:13 am
S_Kumar_S (5/12/2015)
But I think index on hashed column won't work.
It does work.
select * from mytable where email='a@a.com'
Well that's not a search on the hashed column, that's a search on...
May 12, 2015 at 6:12 am
RTaylor2208 (5/12/2015)
The issue is the number of inserts, updates and deletes on the index which cause the index to become more fragmented.
Deletes can't cause logical fragmentation. Inserts can and updates...
May 12, 2015 at 5:19 am
An index on an encrypted column is useless. Encryption is a non-deterministic algorithm, encrypt the same value twice and you won't get the same output.
What you can do is hash...
May 12, 2015 at 4:23 am
friend.vasu (5/12/2015)
okay.. i can put it my question like this.. how can i optimise my SP ?
No idea - http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 12, 2015 at 3:32 am
Why? That doesn't make any sense. It's no something that can be looped over, it won't make the code clearer, faster or anything else.
May 12, 2015 at 3:16 am
nycdotnet (5/11/2015)
May 12, 2015 at 3:03 am
nycdotnet (5/11/2015)
Is this the correct behavior for some reason?
It is indeed correct (and documented) behaviour.
Binding order for columns is first to tables within the subquery, if no...
May 12, 2015 at 2:59 am
No. A clustered SQL instance can only see shared drives that are added as dependencies of the SQL Service.
And if you back up to the local drive, what happens when...
May 12, 2015 at 2:53 am
There's a time on the LOP_BEGIN_XACT (begin transaction), so if you can tie the split back to a transaction you can get a time. I did say with a lot...
May 11, 2015 at 2:38 pm
Viewing 15 posts - 5,956 through 5,970 (of 49,571 total)