Viewing 15 posts - 8,251 through 8,265 (of 19,560 total)
Evil Kraig F (10/17/2011)
Trey Staker (10/17/2011)
Day 1 of the Itzik's Advanced t-sql class and it surpasses my high expectations. Deep dives into indexes before noon.
I cry now Trey..... 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
October 17, 2011 at 3:36 pm
Trey Staker (10/17/2011)
Day 1 of the Itzik's Advanced t-sql class and it surpasses my high expectations. Deep dives into indexes before noon.
Sounds like my kind of fun
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
October 17, 2011 at 3:27 pm
You're welcome.
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
October 17, 2011 at 2:56 pm
For grins - export the package from your server and execute that exported package from bids. Also, verify the configurations, command line, variables and so forth that are 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
October 17, 2011 at 2:49 pm
Steve Cullen (10/17/2011)
SELECT Empid, Name, EmergContact,ROW_NUMBER() OVER (PARTITION BY Empid order BY Name) [Number]
FROM table
Yup - that should pretty much do 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
October 17, 2011 at 2:43 pm
And you get no error message - the job just spins?
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
October 17, 2011 at 2:42 pm
Microsoft® SQL Server® 2008 T-SQL Fundamentals
and many others by Itzik Ben-Gan
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
October 17, 2011 at 2:18 pm
When you run it in BIDS, are you running it with the same account that runs it in the job?
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
October 17, 2011 at 2:09 pm
A few things could contribute. A dynamic swap file for the OS, Memory that is not fully seated, memory that has gone bad.
All of those things can cause delays...
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
October 17, 2011 at 2:07 pm
Have a look at the Row_Number() windowed function.
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
October 17, 2011 at 1:59 pm
ALZDBA (10/17/2011)
SQLserver can have issues when these values are equal.
If this is a dedicated box, why would 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
October 17, 2011 at 1:37 pm
Evil Kraig F (10/17/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
October 17, 2011 at 1:30 pm
Evil Kraig F (10/17/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
October 17, 2011 at 1:29 pm
L' Eomot Inversé (10/17/2011)
Revenant (10/17/2011)
Dude63 (10/17/2011)
nwerner (10/17/2011)
EBCDICMainframe
Big Blue
Customer control tactic?
Extraordinarily Bad Coding Designed to Imprison Customers
Me likey
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
October 17, 2011 at 12:11 pm
Take a look at Lynns comments in that case. You may be better off to just do daily fulls.
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
October 17, 2011 at 10:40 am
Viewing 15 posts - 8,251 through 8,265 (of 19,560 total)