Viewing 15 posts - 5,791 through 5,805 (of 49,552 total)
Without knowing what columns are in the table, all I can suggest is the AVG function, maybe with a GROUP BY.
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 25, 2015 at 4:46 am
You can use the Generate Scripts to script data, but do be careful about the number of rows. There's a lot of overhead in a script of the data because...
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 25, 2015 at 4:39 am
I strongly recommend that you don't script the data. The file sizes get very large and Management Studio often can't handle the large files.
Script the table (right click table ->...
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 25, 2015 at 4:29 am
Functions on a column don't prevent index usage. They prevent index seeks. The index can always be scanned, but scans are usually less efficient than seeks
Also, you cannot draw conclusions...
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 25, 2015 at 3:27 am
Master files shows the default size, database files shows the actual size. Only TempDB resets to default size on server start.
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 25, 2015 at 1:26 am
You're not going to get any better than that. By the looks of the reads, you're fetching the majority portion of the table and all the columns. As long as...
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 25, 2015 at 1:24 am
audiocool (5/24/2015)
Is that Remote desktop connection ? If yes, we all login to SQL Server via Remote Desktop Connection.
Well there's part of your problem.
If this is not recommended, what will...
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 25, 2015 at 1:21 am
sys.dm_tran_locks, identify the session holding the locks, figure out what that session is doing and what the consequences of killing the session will be. If acceptable, kill the session.
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 25, 2015 at 1:18 am
TomThomson (5/24/2015)
My comment was not intended as criticism of your editorial, as I rate it as one of the best editorials I've seen here - so I'm sorry if...
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 25, 2015 at 1:15 am
WhiteLotus (5/24/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 25, 2015 at 1:12 am
WhiteLotus (5/24/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 25, 2015 at 1:11 am
jurgen.lottermoser (5/24/2015)
wouldn't having the same values in both columns in this case mean turning the ints into strings rather than having the same number in both of them?
You could certainly...
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 24, 2015 at 4:30 pm
TomThomson (5/23/2015)
But the scientific method doesn't generally lead to proofs - <large snip>
Of course, it's a fair bit more complex than what I wrote. The full scope is well beyond...
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 24, 2015 at 1:57 pm
Jacob Wilkins (5/23/2015)
(e.g., will making a particular change to this stored procedure result in shorter execution time, and if so, is it at the cost of increased CPU, etc.?).
All...
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 23, 2015 at 2:09 pm
meilenb (5/23/2015)
My Point is that it "could" be a completely different conversation.
It is a completely different conversation, because INT doesn't automatically mean artificial key and String doesn't automatically mean natural...
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 23, 2015 at 2:07 pm
Viewing 15 posts - 5,791 through 5,805 (of 49,552 total)