Viewing 15 posts - 5,956 through 5,970 (of 49,552 total)
You don't need profiler. Turn traceflag 1222 on and you'll get a deadlock graph written to the error log.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 13, 2015 at 2:55 am
colin Robinson-345240 (5/12/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 12, 2015 at 3:16 am
nycdotnet (5/11/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 11, 2015 at 2:38 pm
You need to escape the quotes around SupportRole and SupportUser as you did around the database names.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 11, 2015 at 10:07 am
Viewing 15 posts - 5,956 through 5,970 (of 49,552 total)