Forum Replies Created
Viewing 15 posts - 2,911 through 2,925 (of 9,720 total)
-
RE: Are the posted questions getting worse?
Brandie Tarvin (1/27/2015)
venoym (1/27/2015)
BrainDonor (1/27/2015)
Sean Lange (1/23/2015)
Oh the cursors are unbelievably stuipd. They are used to count!!!
set @Counter = 1
while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin
...
-
RE: Are the posted questions getting worse?
venoym (1/27/2015)
BrainDonor (1/27/2015)
Sean Lange (1/23/2015)
Oh the cursors are unbelievably stuipd. They are used to count!!!
set @Counter = 1
while exists(select * from StupidlyLargeHeap (nolock) where someColume = @Counter) begin
...
-
RE: SQL Query invoked by Crystal Reports v9.2 Performance Issue
So does it recompile each time it runs or did it just recompile the once?
-
RE: SQL Server closes database backup request to NAS share in middle of restore
Brandie Tarvin (1/26/2015)
SQLRNNR (1/26/2015)
Is this a VM or physical?VM
I have just been corrected. Our servers are physical.
-
RE: SQL Server closes database backup request to NAS share in middle of restore
SQLRNNR (1/26/2015)
K, change the Packet size in SQL Server. But that won't help any with the fact that a file copy also fails.Change it to the same size as...
-
RE: Are the posted questions getting worse?
My coworker just sent me this:
“I woke up SO this morning telling them that we're getting a blizzard tonight. They said, half-asleep, “from Dairy Queen?” Yes.”
-
RE: Are the posted questions getting worse?
Grant Fritchey (1/26/2015)
What it's like, at this exact moment, everywhere in Massachusetts.BWahahahahaaha.
-
RE: SQL Server closes database backup request to NAS share in middle of restore
Brandie Tarvin (1/26/2015)
SQLRNNR (1/26/2015)
Have him do the trace for the file copy. If the file copy is also puking at about 80%, you can pretty much eliminate SQL Server...
-
RE: SQL Server closes database backup request to NAS share in middle of restore
SQLRNNR (1/26/2015)
When he looked at the trace, did your sysadmin take note of the packet sequence to see if maybe SQL Server received a packet out of sequence (it most... -
RE: Are the posted questions getting worse?
David Burrows (1/26/2015)
Koen Verbeeck (1/26/2015)
GilaMonster (1/26/2015)
Sean Lange (1/26/2015)
Jack Corbett (1/26/2015)
Sean Lange (1/23/2015)
Oh lordy...I just handed a stored proc and was asked advice on how to make it faster.... -
RE: Are the posted questions getting worse?
HELP! I'm having a "restoring database from a NAS share" issue and the problem appears to be the server, not the NAS / network. Can someone stop by and give...
-
RE: When do you use CREATE DATABASE ... WITH FOR ATTACH_REBUILD_LOG?
brendan woulfe (1/23/2015)
I had a client who took a database offline and deleted the transaction log file for one of their production databases (someone recommended they do this, and I... -
RE: Are the posted questions getting worse?
GilaMonster (1/26/2015)
Steve Jones - SSC Editor (1/23/2015)
Sioban Krzywicki (1/23/2015)
GilaMonster (1/23/2015)
I haven't got any clue for a costume. Maybe cheat, buy a green hoodie and go as Arrow (but without a... -
RE: SQL Query invoked by Crystal Reports v9.2 Performance Issue
dwain.c (1/25/2015)
Brandie Tarvin (1/23/2015)
Have you tried recreating the proc without the versioning? (I.E. without the "; 1") and then executing it through your code that way? Then see if it... -
RE: Are the posted questions getting worse?
Sean Lange (1/23/2015)
Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is 3700 lines long, there are almost 200 parameters...
Viewing 15 posts - 2,911 through 2,925 (of 9,720 total)