Viewing 15 posts - 6,466 through 6,480 (of 19,560 total)
crookj (4/6/2012)
SQLRNNR (4/6/2012)
pteranodonPterodactyl
pterosaur
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
April 6, 2012 at 8:43 am
I was thinking this was a tricky question due to the ambiguity. Good to see others felt the same way.
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
April 6, 2012 at 8:41 am
Brandie Tarvin (4/6/2012)
Jack Corbett (4/6/2012)
I may need to buy a new laptop soon. I use it for work...
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
April 6, 2012 at 8:38 am
pteranodon
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
April 6, 2012 at 8:35 am
Even with that, the case statement you provided is not nested.
What Version and SP level is your SQL Instance?
A nested case (where 10 levels is the limitation) looks like:
case when...
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
April 6, 2012 at 8:29 am
Here is an example of a case statement (that I know works) that contains more than 10 when statements
http://reportingservicestnt.blogspot.com/2010/10/subscriptions-sql.html
The nesting level problem you are encountering is not with the case...
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
April 6, 2012 at 12:21 am
How about we start with what you think the answers are for these questions?
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
April 6, 2012 at 12:18 am
I think this is the article
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
April 5, 2012 at 9:17 pm
DBCC Shrinkfile.
I would do it in stages - reduce it by 100-200GB each stage.
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
April 5, 2012 at 4:27 pm
peter 82125 (4/5/2012)
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
April 5, 2012 at 4:25 pm
opc.three (4/5/2012)
SQLRNNR (4/5/2012)
Minnesota - Viking (4/5/2012)
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go...
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
April 5, 2012 at 4:24 pm
Minnesota - Viking (4/5/2012)
My question in other words is To configure the SQL Server Database Engine to listen on an additional TCP port, should one MUST go through 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
April 5, 2012 at 4:12 pm
The Dixie Flatline (4/5/2012)
SQLRNNR (4/5/2012)
Brandie Tarvin (4/5/2012)
Lynn Pettis (4/5/2012)
Oh well, no bomb. Back to work.Was it Twinkies?
Strawberry flavored with a touch more fiber than normal.
Save some for supplies in...
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
April 5, 2012 at 4:10 pm
You will have a 1 TB database and want to shrink to leave only 50GB free?
What is the size of your largest table?
You should not shrink the database to 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
April 5, 2012 at 3:56 pm
jitendra.padhiyar (4/5/2012)
Please revert me... I am doing in-place upgradation and still the same error confusing me.
" Rule SQL Server 2008 Feature upgrade failed. The specified edition upgrade is not...
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
April 5, 2012 at 3:51 pm
Viewing 15 posts - 6,466 through 6,480 (of 19,560 total)