Viewing 15 posts - 5,281 through 5,295 (of 19,560 total)
Evil Kraig F (1/9/2013)
Brandie Tarvin (1/9/2013)
Wow. Brain bleach. NOW PLEASE.Oh, c'mon. I'm not THAT ugly...
*sighs*
Snake LOVER:alien:
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
January 9, 2013 at 1:32 pm
Evil Kraig F (1/9/2013)
Jeff Moden (1/9/2013)
dwain.c (1/8/2013)
http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx
Come on! Surely some of you heavyweights can whip up 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
January 9, 2013 at 12:04 pm
No suggestions and I am in a similar boat trying to just get the score report for one of my more recent exams. They can't seem to figure out...
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
January 9, 2013 at 10:37 am
JAZZ Master (1/9/2013)
SQLRNNR (1/9/2013)
spasmmuscle
atrophy
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
January 9, 2013 at 10:34 am
sqlgreg (1/9/2013)
How is it possible that the VM Admin would move a SQL Server and the SQL Server folks not be aware ahead of time? That's a real problem.
I completely...
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
January 9, 2013 at 9:40 am
You can run a little POSH script like this one every now and then (or on a regular basis)
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
January 9, 2013 at 9:37 am
sqlnaive (1/9/2013)
Dineshbabu (1/8/2013)
Andre Ranieri (1/8/2013)
Nice question - I wonder if the question category should have been table aliases instead of joins 🙂Thanks,
Andre Ranieri
+1
I agree with both Andre and Dineshbabu. 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
January 9, 2013 at 8:59 am
spasm
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
January 9, 2013 at 8:57 am
crookj (1/9/2013)
Revenant (1/9/2013)
Daniel Bowlin (1/9/2013)
sinusheadache
Yourgraine ( I don't want any part of it!!!)
LOL
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
January 9, 2013 at 8:57 am
I recommend against changing the database to simple and then back to full for the checkdb. I can sort of see that being doing for the reindex but I'd...
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
January 8, 2013 at 10:24 pm
Hard to say either way without knowing what the table design(s) is(are). In addition is to know what the queries are.
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
January 8, 2013 at 10:06 pm
dwain.c (1/8/2013)
Am I the only one that finds these kinds of SQL puzzles fun?http://www.sqlservercentral.com/Forums/Topic1403293-392-1.aspx
Come on! Surely some of you heavyweights can whip up a cool solution to it.
Maybe 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
January 8, 2013 at 9:05 pm
Here is a script that works very well for table space. The linked server aspect though is something I have never considered adding to it. I just run...
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
January 8, 2013 at 8:54 pm
With these new servers, did you make sure the energy saving features were disabled in bios?
SQL Server does not play well with servers that have the Energy saving features enabled.
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
January 8, 2013 at 5:14 pm
This query should help
select top 10
t1.session_id,
t1.request_id,
t1.task_alloc,
t1.task_dealloc,
(SELECT SUBSTRING(text, t2.statement_start_offset/2 + 1,
(CASE WHEN statement_end_offset = -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
January 8, 2013 at 5:08 pm
Viewing 15 posts - 5,281 through 5,295 (of 19,560 total)