Viewing 15 posts - 1,291 through 1,305 (of 19,564 total)
jasona.work (5/21/2015)
If I bring up the fact that I've not read The Thread from start to finish, does my secret SSC decoder ring get taken away?:w00t:
YES, so you better keep...
May 21, 2015 at 9:53 am
Grant Fritchey (5/21/2015)
May 21, 2015 at 8:00 am
Brandie Tarvin (5/21/2015)
Jeff Moden (5/20/2015)
audiocool (5/17/2015)
- OS and SQL Server 2012 are 64 bits
- The server equipped with SQL Server 2012 and McAfee Virus Scan Enterprise v8.8
...
May 21, 2015 at 7:58 am
David Burrows (5/21/2015)
Sean Lange (5/21/2015)
cunningham (5/21/2015)
soooo this is where you lot go to blow off steam!Yes indeed!!! Welcome to the "water cooler" commonly referred to as "the thread". 😀
Meh! The...
May 21, 2015 at 7:53 am
If log_reuse_wait_desc says it is waiting on replication and replication is getting further behind, you could re-initialize the subscription.
Once it is in sync, you should take a log backup.
May 20, 2015 at 11:59 pm
grkanth81 (5/20/2015)
I would like to get the sql query to convert varbinary to datetime.
Here is the value in Varbinary(112) :
0x20202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020323939343730
The expected result should be - 1970-05-29 00:00:00.000
Can you...
May 20, 2015 at 11:54 pm
Wow - amazing how these old threads come back to life sometimes 😉
May 20, 2015 at 2:41 pm
Ed Wagner (5/20/2015)
GilaMonster (5/20/2015)
Eirikur Eiriksson (5/20/2015)
This would be the one that wants to fix ugly queries with a sprinkle of hint perfume when all that's needed is a good shower/rewrite.😎
It...
May 20, 2015 at 2:28 pm
I am going to throw something out there that I see time and again from people migrating from really old hardware to new hardware. It always causes a cpu...
May 20, 2015 at 2:20 pm
GilaMonster (5/20/2015)
Oh, and the page file is high probably because it's the default settings in Windows. The page file is used by the OS, not by SQL Server.
If the page...
May 20, 2015 at 2:18 pm
audiocool (5/20/2015)
if SQL do not use page file, can you explain to me why it eat a lot of the C driver hardisk space. more than 30GB is gone.
Gonna venture...
May 20, 2015 at 2:15 pm
GilaMonster (5/18/2015)
audiocool (5/18/2015)
Sorry we don't have DBA here and everything learn from internet. 🙂
Which is why I'm very strongly suggesting you get a 3rd party in. There are lots of...
May 20, 2015 at 2:08 pm
Eirikur Eiriksson (5/20/2015)
SQLRNNR (5/20/2015)
GilaMonster (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random...
May 20, 2015 at 12:25 pm
GilaMonster (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint. Things...
May 20, 2015 at 12:14 pm
Ed Wagner (5/20/2015)
Grant Fritchey (5/20/2015)
AAARRARARRGGGGHHHH!!!
Sometimes, I just wonder why any of us even try. Reams of good advice from multiple people. All of it ignored. Apply a random query hint....
May 20, 2015 at 11:19 am
Viewing 15 posts - 1,291 through 1,305 (of 19,564 total)