Viewing 15 posts - 19,486 through 19,500 (of 19,560 total)
Thx Bob for the insight.
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
August 25, 2009 at 12:09 pm
I too missed the extra comma but saw the intent of the question. Despite that, it is nice to have learned something about the extra comma in table creates.
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
August 25, 2009 at 12:03 pm
I liked the question - and the previous spatial questions on QotD. Makes you think back a little bit to geography and geometry - woot!
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
August 25, 2009 at 11:53 am
This was a good question. I would have initially ticked the truncate table option but ran some testing and research first. Though accurate, I am not sure I...
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
August 25, 2009 at 11:41 am
The question must have been corrected by the time I answered it. The sql errors with the tags did not exist when I answered this question so it was...
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
August 24, 2009 at 6:27 pm
Keep in mind the question asked for highest and lowest respectively. If construed differently than the highest possible and then the lowest possible datatypes; we would still have to...
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
August 24, 2009 at 6:07 pm
This question was good in that it pointed out something really simple, yet way to easy to overlook when troubleshooting or code-reviewing in the first place.
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
August 24, 2009 at 5:56 pm
Agreed on the spelling issue. I pause for a moment on questions with mis-spellings to make sure there is no trick involved. The flipside though is that 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
August 24, 2009 at 5:45 pm
I found many of the items in this article (as already divulged by Gail), to be somewhat inaccurately founded. That said, with proper documentation and good peer review, this...
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
August 10, 2009 at 10:47 am
Great stuff/thread. Wish i could have made it to that Pass session.
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
July 10, 2009 at 1:32 pm
nice to have a clear explanation.
Good question
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
July 10, 2009 at 1:04 pm
Found this one very interesting. My initial understanding was that of logs having 8k pages. However - I think it comes down to as Steve said - trivia...
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
July 10, 2009 at 12:10 pm
If your log is full, is your disk full too?
What is the growth set to for your log?
What is your recovery model (full, simple)?
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
July 10, 2009 at 11:58 am
Another reason to have different instances would be (again along the security lines) to better segregate client databases. More politics, more administrative duties.
For your additional instance, is your cluster...
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
July 10, 2009 at 11:51 am
Though this is not my question, thanks Elliott for the answer. This will prove useful in my environment as well.
In addition to using TFS already.
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
July 10, 2009 at 11:42 am
Viewing 15 posts - 19,486 through 19,500 (of 19,560 total)