Viewing 15 posts - 1,291 through 1,305 (of 19,560 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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 21, 2015 at 9:53 am
Grant Fritchey (5/21/2015)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2015 at 11:54 pm
Wow - amazing how these old threads come back to life sometimes 😉
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
May 20, 2015 at 11:19 am
Viewing 15 posts - 1,291 through 1,305 (of 19,560 total)