Viewing 15 posts - 5,281 through 5,295 (of 26,490 total)
MMartin1 (5/8/2015)
New Born DBA (5/8/2015)
J Livingston SQL (5/8/2015)
New Born DBA (5/6/2015)
May 8, 2015 at 1:21 pm
New Born DBA (5/8/2015)
May 8, 2015 at 9:44 am
MMartin1 (5/8/2015)
New Born DBA (5/7/2015)
Lynn Pettis (5/7/2015)
New Born DBA (5/7/2015)
Sorry, but I actually spit soda out my nose on this comment:
Well I hope you are OK. 😀
It isn't a system...
May 8, 2015 at 8:30 am
I really want to say "Write it yourself. We aren't here to do your work for you."
May 7, 2015 at 4:10 pm
Sean Lange (5/7/2015)
Lynn Pettis (5/7/2015)
Sean Lange (5/7/2015)
Alvin Ramard (5/7/2015)
Try using the LEFT function instead of SUBSTRING to see if it will run any faster.
The problem is for the first join...
May 7, 2015 at 12:49 pm
QuickToLearn (5/7/2015)
It is for the internal requirement. Is there any way to exclude that part ....AS [DBO]?
Not that I am aware. You either have to modify the...
May 7, 2015 at 12:47 pm
Sean Lange (5/7/2015)
Alvin Ramard (5/7/2015)
Try using the LEFT function instead of SUBSTRING to see if it will run any faster.
The problem is for the first join they want the first...
May 7, 2015 at 12:40 pm
Jacob Wilkins (5/7/2015)
May 7, 2015 at 12:33 pm
Why are you trying to drop the AS DBO? From BOL:
AS <database_principal>
Specifies a principal from which the principal executing this query derives its right to grant the...
May 7, 2015 at 12:24 pm
GilaMonster (5/7/2015)
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
How about: Partitioning for performance, what it really means. 😛
This one not good enough? https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Hey,...
May 7, 2015 at 12:17 pm
Even a small network glitch can cause a failure of a backup to a UNC location on another server. If you have the space on the server it is...
May 7, 2015 at 12:14 pm
GilaMonster (5/7/2015)
Lynn Pettis (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
How about: Partitioning for performance, what it really means. 😛
This one not good enough? https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Hey, I'm just going...
May 7, 2015 at 12:09 pm
Not having implemented clustering in a production environment, but don't you access the clustered instance with a virtual server name, and that it doesn't matter which physical server is actually...
May 7, 2015 at 12:07 pm
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
How about: Partitioning for performance, what it really means. 😛
May 7, 2015 at 12:00 pm
Jeff Moden (5/7/2015)
Lynn Pettis (5/7/2015)
Jeff Moden (5/6/2015)
Lynn Pettis (5/6/2015)
ramana3327 (5/6/2015)
May 7, 2015 at 11:38 am
Viewing 15 posts - 5,281 through 5,295 (of 26,490 total)