Viewing 15 posts - 1,456 through 1,470 (of 1,583 total)
Have your System/Domain admin create a security group in Active Directory and add in all the developers who should have this ability. Once that's created, add that group as...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 22, 2011 at 1:11 pm
Is there a better cost/ratio by adding a column(s) to the index versus including them?
I've sometimes noticed the index will grow considerably larger by adding columns, but less when the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 22, 2011 at 1:02 pm
Try setting up a system DSN driver first through ODBC on the server itself at the OS level, then create the linked server using the DSN from what you just...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 22, 2011 at 8:37 am
Transaction or no, nothing is stopping both from selecting the same value from the table in the first statement
Gail, in your test yes this is true, however in the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 11, 2011 at 2:20 pm
They they ran (on 8 different tries) from 10-15 seconds
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 11, 2011 at 1:59 pm
FYI, the memory and CPU don't really move much during these reporting execution times...the CPU hovers around 30%, and the memory stays even. The disk reads spike up to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 11, 2011 at 1:07 pm
I tried the test but they still didn't execute at the same time:
Window 1:
WAITFOR TIME '13:42:00:000'
SELECT GETDATE()
-- exec reporting procedure here
Returns: 2011-08-11 13:42:00.003
Window 2:
WAITFOR TIME '13:42:00:000'
SELECT...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 11, 2011 at 1:00 pm
I use SQL Diagnostic Manager (Idera) and it works quite well. I like the historical views and the fact that it basically has every PerfMon you could ever...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 5, 2011 at 8:40 am
Thanks so much for these tips!
I've already made sure the index was there but about putting a WAITFOR in there or placing them on separate spindles (makes perfect sense now...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 2, 2011 at 1:30 pm
Thanks, I will look at replacing ours with this nifty code!
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 2, 2011 at 1:07 pm
How about something like this?
Create a function to handle the parsing you need, then just call it when doing the INSERTS
Create scalar function
USE [F1Settings]
GO
/****** Object: UserDefinedFunction [dbo].[fx_FormatArrayText] ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 2, 2011 at 12:46 pm
In that case,IMO you're going to be limited to using a custom solution than anything you'll find out of the box...
I'd try pitching the centralized database idea...If that's not possible...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 2, 2011 at 10:41 am
Are you looking to sync all three databases back to each other or simply back to a centralized DB (sorry if I'm not reading your original post correctly)?
If you're only...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 2, 2011 at 9:06 am
How are your drives set up? Are they single drives? Raided? How are your SQL DB files placed on the drives?
It's difficult to say what's going on here without...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 20, 2011 at 3:03 pm
Wow.
Such a simplistic approach and the never-ending procedure completed in 7 minutes and 40 seconds. I added the MAXDOP and PAGLOCK, and reduced the batch size to 5000...
SELECT *,...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
July 19, 2011 at 9:28 pm
Viewing 15 posts - 1,456 through 1,470 (of 1,583 total)