Viewing 15 posts - 196 through 210 (of 465 total)
GilaMonster (12/14/2015)
December 14, 2015 at 1:16 pm
Why would a UDF run more than once per row, unless it's used more than once per row?
December 14, 2015 at 7:21 am
Erland Sommarskog (11/16/2015)
I describe this technique in detail in an...
November 16, 2015 at 6:54 am
Erland Sommarskog (11/16/2015)
1) It is not the way you think it is, but procedure and table have different owners. Check the two objects in sys.objects,...
November 16, 2015 at 6:31 am
EdVassie (10/17/2015)
It sounds like your users have a Stage 4 predicate in their query...
They do, sort of, and office politics are not a problem. There is no management between us...
October 17, 2015 at 10:42 am
vedau (10/14/2015)
http://www.sqlskills.com/blogs/paul/correctly-adding-data-files-tempdb/
I'm familiar with that site. However, it has nothing to say about the situation I described.
October 14, 2015 at 3:00 pm
I understand that using multiple files for TempDB can be useful to spread the workload, but does it make any sense when the server is very lightly loaded? Like, so...
October 14, 2015 at 11:52 am
John Mitchell-245523 (9/2/2015)
Goodness! If the IT department isn't fulfilling one of its most important roles by taking backups, then that needs escalating to the very top, doesn't it?John
Backups are...
September 2, 2015 at 8:38 am
John Mitchell-245523 (9/2/2015)
September 2, 2015 at 7:53 am
Jeff Moden (8/14/2015)
pdanes (8/14/2015)
August 15, 2015 at 3:38 am
If you are manually running some code in SSMS, table variables have the additional advantage of being generated fresh on every run. Temp tables stay around, and you have to...
August 14, 2015 at 6:23 am
Well, I've made some progres on it. I had to manually change a bunch of permissions, and I got it running again. However, I have no idea why something that...
June 21, 2015 at 2:29 pm
ScottPletcher (6/19/2015)
When you use "EXECUTE AS OWNER" the owner cannot be...
June 19, 2015 at 3:38 pm
Joie Andrew (6/19/2015)
Was the sa login recently disabled or renamed on the instance where your development is pointing to?
As far as I know, nothing has changed. At least, I haven't...
June 19, 2015 at 1:27 pm
Mode con works, Format-Table -wrap still truncates. Thank you both.
June 3, 2015 at 11:29 pm
Viewing 15 posts - 196 through 210 (of 465 total)