Viewing 15 posts - 5,671 through 5,685 (of 7,168 total)
I can't help thinking about how this query might have been faster on the old hardware given the same plan (can you confirm the plan looked the same on the...
July 5, 2011 at 11:03 am
Ninja's_RGR'us (7/5/2011)
Gianluca Sartori (7/5/2011)
Ninja's_RGR'us (7/5/2011)
Gianluca Sartori (7/5/2011)
However 4 MLN rows from both tables is a huge load. I suspect it would run much better with a...
July 5, 2011 at 10:44 am
jimmerthy (7/3/2011)
July 5, 2011 at 10:27 am
Do you use a lot of Linked Servers?
Found this too:
http://www.sqlservercentral.com/Forums/Topic336973-146-1.aspx
July 5, 2011 at 10:23 am
EdVassie (7/5/2011)
Sometimes things are not working the way they should and you have to go behind the scenes to fix it. For example fixing satellites[/url]
Thanks for the chuckle on...
July 5, 2011 at 9:49 am
I know you're capable Ben but if you have not used it and get shy about SSB one time saver I'll throw out there about Agent jobs: make one schedule...
July 5, 2011 at 9:41 am
EdVassie (7/5/2011)
July 5, 2011 at 9:28 am
** Sweet ** Plan Guides are available in 2008 Web Edition.
as2higpark (7/5/2011)
Any ideas on how to deal with this offender or am I left to try to convince the developers...
July 5, 2011 at 9:10 am
repicurus (7/4/2011)
...abbreviated...I would check to see if HYPER-THREADING (not "Hyper-V") is enabled in the BIOS for these servers.
If so - disable it.
...abbreviated...
I have disabled Hyperthreading on a server suffering from...
July 4, 2011 at 6:12 pm
You could also use Dynamic SQL for the task but it seems like a waste of resources to incur the overhead of looking up the list of linked servers and...
July 4, 2011 at 8:47 am
Some options:
> SQL Trace can provide those details on a macro level.
> Use SQL Audit to capture "Database-Level Audit Actions" (Enterprise Edition only)
> manually capture DDL events in a...
July 4, 2011 at 8:41 am
pandu.72 (7/3/2011)
As per my requirement I need to call a normal SQL server stored procedure...
July 4, 2011 at 8:04 am
CXPACKETs are going to happen as long as MAXDOP != 1, the trick is to reduce them. If this is primarily an OLTP system there may not be much point...
July 4, 2011 at 7:50 am
Are you trying to initiate a shadow copy on your own? Typically a backup software or hardware management software interacts with VSS for you. What are you trying to do?
July 4, 2011 at 7:38 am
Viewing 15 posts - 5,671 through 5,685 (of 7,168 total)