Viewing 15 posts - 8,581 through 8,595 (of 49,552 total)
What does the procedure do? Can you post code?
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
July 1, 2014 at 4:10 am
May I suggest you post mySQL questions on a mySQL site (like http://forums.mysql.com/). This site is specifically for Microsoft SQL Server.
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
July 1, 2014 at 2:54 am
What exactly is wrong with updating a column to NULL?
The Nolock hint will be ignored since it's on the target table for an update (that should be documented in...
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
July 1, 2014 at 2:45 am
Before you go the filegroup route.... The DB needs to be in full recovery and you need log backups covering the range from the oldest read-write filegroup backup to the...
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
July 1, 2014 at 2:40 am
Do you have a clean backup of the MSDB database?
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
July 1, 2014 at 2:38 am
S_Kumar_S (6/29/2014)
I have already tried disk queue length, processor time, disk read and write, peges/sec etc...
Well.... those are interesting choices of counters. Do you know how (or how not) to...
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
June 30, 2014 at 10:26 am
The answer to both of those is 'test it'
Read committed snapshot can be very useful, you have to test and make sure that the overhead on TempDB isn't too bad....
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
June 30, 2014 at 10:24 am
Views can't have primary keys.
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
June 27, 2014 at 11:13 am
We're not here to do your job for you. If you're going to miss a deadline, tell your manager beforehand that you're behind. If you don't know T-SQL, then make...
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
June 27, 2014 at 8:43 am
I suspect not that much can be done while all those REPLACE and TRIM functions are needed in the WHERE clause. Is the data really that messy?
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
June 27, 2014 at 8:39 am
Grant Fritchey (6/27/2014)
You have a MIN without an ORDER BY. That can lead to bad data
How? Top without an order by I can see, MIN (the minimum value) should...
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
June 27, 2014 at 8:26 am
Duplicate thread, please stick to a single thread per question: http://www.sqlservercentral.com/Forums/Topic1586319-391-1.aspx
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
June 27, 2014 at 8:24 am
The total memory should be fine, but to be sure rather use Perfmon. Available MB for free memory, SQL's Total Server Memory for what it's using
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
June 27, 2014 at 8:21 am
The optimiser estimated that the operator in question would execute 200 times during the course of the query's execution. It's an estimation.
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
June 27, 2014 at 6:51 am
Don't use Task Manager to check SQL Server's memory usage, it can show incorrect values.
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
June 27, 2014 at 6:50 am
Viewing 15 posts - 8,581 through 8,595 (of 49,552 total)