Viewing 15 posts - 5,791 through 5,805 (of 49,571 total)
Without knowing what columns are in the table, all I can suggest is the AVG function, maybe with a GROUP BY.
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...
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 ->...
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...
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.
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...
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...
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.
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...
May 25, 2015 at 1:15 am
WhiteLotus (5/24/2015)
May 25, 2015 at 1:12 am
WhiteLotus (5/24/2015)
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...
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...
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...
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...
May 23, 2015 at 2:07 pm
Viewing 15 posts - 5,791 through 5,805 (of 49,571 total)