Viewing 15 posts - 511 through 525 (of 8,731 total)
June 5, 2018 at 12:09 pm
SELECT * INTO Title2 FROM Title;
Not a good idea. A direct SELECT ... INTO...
June 4, 2018 at 1:01 pm
June 1, 2018 at 9:53 am
Steve Jones - SSC Editor - Wednesday, May 30, 2018 9:09 AMAnyone in Nashville this week for Music City Tech?
If only I...
May 31, 2018 at 12:01 pm
May 31, 2018 at 8:55 am
May 31, 2018 at 8:49 am
There shouldn't be any performance difference, but the second method might reduce the length of the code by not having to repeat it.
May 30, 2018 at 11:50 am
May 30, 2018 at 8:47 am
I didn't post any idea or sugestion as I believe that...
May 30, 2018 at 8:44 am
LOOP, HASH & MERGE are JOIN hints to tell the SQL Server engine what physical operation should use for that specific JOIN. Usually, the engine will choose the best operation...
May 30, 2018 at 8:31 am
May 30, 2018 at 6:11 am
That's because it wasn't running anything inside the cursor to reference all the databases. With the changes, it tried to read from the databases and the permissions came into effect.
May 24, 2018 at 1:33 pm
Yeah if you are spending several hours a week because of format then...
May 24, 2018 at 10:01 am
The current description seems to be a basic aggregate query using AVG(). We just want to know if something else is missing.
May 24, 2018 at 9:54 am
That might be because you're not changing your dynamic code on every iteration, so you're just trying to run a null value.
Set NOCOUNT ON;
Declare...
May 24, 2018 at 9:53 am
Viewing 15 posts - 511 through 525 (of 8,731 total)