Viewing 15 posts - 7,486 through 7,500 (of 19,560 total)
jkp2311 (12/20/2011)
@SSChasing Mays,I am using for my personal use.
i am not using for business purpose.
It doesn't matter - it is still piracy. The developer edition costs $50.
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
December 20, 2011 at 8:53 am
Revenant (12/20/2011)
SQLRNNR (12/19/2011)
Revenant (12/19/2011)
SQLRNNR (12/19/2011)
crookj (12/19/2011)
SQLRNNR (12/19/2011)
chewChewy Chewy (The Ohio Express)
Choo Choo
Chattanooga
Nostalgia
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
December 20, 2011 at 8:24 am
nice 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
December 19, 2011 at 10:20 pm
Thanks for the nice 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
December 19, 2011 at 10:10 pm
Wow - > 1000 lines in a view. That sounds like Microsoft CRM. In many cases we stopped accessing the views because they were so large (line count)...
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
December 19, 2011 at 9:57 pm
Have a look on this blog:
http://sqlvariant.com/wordpress/index.php/tag/powershell/
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
December 19, 2011 at 8:24 pm
Nice answer Michael.
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
December 19, 2011 at 8:22 pm
What edition of 2k8 are you trying to install (dev, enterprise)?
Where did you get the installable? Via download? It sounds like a corrupt installable.
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
December 19, 2011 at 5:24 pm
Revenant (12/19/2011)
SQLRNNR (12/19/2011)
crookj (12/19/2011)
SQLRNNR (12/19/2011)
chewChewy Chewy (The Ohio Express)
Choo Choo
Chattanooga
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
December 19, 2011 at 5:21 pm
As Sean pointed out, your query is only limited to the records that match the conditions of your WHERE clause. If you need more records than that, then 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
December 19, 2011 at 4:08 pm
Superb 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
December 19, 2011 at 4:06 pm
Try a windowed function ( such as ROW_NUMER()) in a cte. Order that windowed function by desc. Then select row_number 2 from that result set.
Play with it 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
December 19, 2011 at 3:59 pm
Are you running VS under the same account.
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
December 19, 2011 at 3:53 pm
crookj (12/19/2011)
SQLRNNR (12/19/2011)
chewChewy Chewy (The Ohio Express)
Choo Choo
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
December 19, 2011 at 3:43 pm
David Moutray (12/19/2011)
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
December 19, 2011 at 3:39 pm
Viewing 15 posts - 7,486 through 7,500 (of 19,560 total)