Viewing 15 posts - 4,786 through 4,800 (of 19,560 total)
Cliff Jones (3/28/2013)
bcsims 90437 (3/28/2013)
Terry300577 (3/28/2013)
CadenceChirunning
(Just did 4 days of chirunning/chiwalking instructor training, and got the topic of 'cadence' for my practical exam.)
Chillaxing
Chisleeping
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 28, 2013 at 10:08 am
L' Eomot Inversé (3/28/2013)
GilaMonster (3/28/2013)
Welcome to Books Online. I personally love the sections that are completely, blatantly wrong.
I prefer the sections that mix wrong and right, especially the ones that...
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 28, 2013 at 8:59 am
Lowell (3/28/2013)
BrainDonor (3/28/2013)
Lynn Pettis (3/27/2013)
What to make of this?May not be what I was thinking. Good.
"I'm a DBA, it turns out"
How do you suddenly discover that you're a DBA?
it's...
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 28, 2013 at 8:22 am
Stefan Krzywicki (3/28/2013)
Microsoft technet says Simple = Y steps, authenticator =...
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 28, 2013 at 8:11 am
EZ PZ
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 28, 2013 at 8:06 am
They will not if you export as ssis packages.
Maint plans have a lot of shortcomings. This happens to be one of them. Many DBAs use script based maintenance...
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 27, 2013 at 9:41 pm
You can export them as SSIS packages and then import them back into msdb. However, they would then be SSIS packages.
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 27, 2013 at 5:25 pm
Lynn Pettis (3/27/2013)
What to make of this?May not be what I was thinking. Good.
looks like Gail took care of it. Wish I had seen it sooner.
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 27, 2013 at 5:15 pm
Stefan Krzywicki (3/27/2013)
Don't you just love when BOL is showing two ways of doing something, but includes subtle errors and inconsistencies?
Seems almost expected with BOL
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 27, 2013 at 5:11 pm
Along the lines of the upgrade - this sounds a lot like an issue caused by having the power save features enabled in BIOS. New boxes have it on...
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 27, 2013 at 8:29 am
The ident column is a good option. The one time build of it would be a tradeoff in time that will eventually be recovered by the process running faster.
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 27, 2013 at 8:26 am
You can do it. I prefer to avoid master for the reason of having one more database to check for objects when migrating to a different server (for example)....
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 27, 2013 at 8:23 am
EZ PZ today.
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 27, 2013 at 8:04 am
mtassin (3/27/2013)
Stuart Davies (3/27/2013)
Thanks for the question - easy point today+1 Yup.... nice when I don't have to think.... rare... but nice 🙂
+1
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 27, 2013 at 7:59 am
Is the transaction log full or is it that the log grew and filled the disk?
Is the issue on the principal or on the mirror?
Do you have additional disk space...
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 25, 2013 at 10:21 pm
Viewing 15 posts - 4,786 through 4,800 (of 19,560 total)