Viewing 15 posts - 4,846 through 4,860 (of 19,560 total)
L' Eomot Inversé (3/14/2013)
Stefan Krzywicki (3/14/2013)
SQLRNNR (3/14/2013)
Happy Pi day.I'm looking forward to Pi minute in 1 hour, 17 minutes.
Well, you were five hours late then. And even if 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
March 14, 2013 at 12:09 pm
Happy Pi day.
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
March 14, 2013 at 11:50 am
No errors posted in any log?
Not in the storage logs?
Not in the OS logs?
Not in the SQL logs?
If not in any of those places, then maybe somebody has created a...
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
March 14, 2013 at 10:14 am
Lynn Pettis (3/14/2013)
TheSQLGuru (3/14/2013)
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
March 14, 2013 at 10:11 am
Very good point Steve. Checkdb is insurance. I just ran into two clients (new) in the same day with some level of corruption in their databases. Neither...
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
March 14, 2013 at 12:35 am
Oftentimes you need to place a derived column transformation to force the conversion.
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
March 14, 2013 at 12:28 am
Lokesh Vij (3/13/2013)
demonfox (3/13/2013)
an easy one for the day !!!thanks for the question
+1
Thanks David!
+2
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
March 14, 2013 at 12:22 am
Has the maintenance plan worked in the past?
Does it throw the same error no matter where you try to open it (your desktop or from the server)?
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
March 14, 2013 at 12:20 am
Is it throwing any errors into the error logs? Please post the errors.
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
March 14, 2013 at 12:18 am
shannonjk (3/13/2013)
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
March 13, 2013 at 6:29 pm
Grant Fritchey (3/13/2013)
SQLRNNR (3/13/2013)
That many parallelism deadlocks can mean that you have a lot...
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
March 13, 2013 at 5:57 pm
Grant Fritchey (3/13/2013)
SQLRNNR (3/13/2013)
XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information...
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
March 13, 2013 at 5:55 pm
Erin Ramsay (3/13/2013)
Can you share the DDL for the tables and some sample data?
And also what the desired output should look like?
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
March 13, 2013 at 5:03 pm
Replication won't affect the logins on the either server. Replication won't affect the database users either, on the subscribing server.
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
March 13, 2013 at 1:59 pm
It might be typical for your environment. But that doesn't mean it has to be acceptable.
That many parallelism deadlocks can mean that you have a lot of poor performing...
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
March 13, 2013 at 1:57 pm
Viewing 15 posts - 4,846 through 4,860 (of 19,560 total)