Viewing 15 posts - 2,656 through 2,670 (of 19,560 total)
Koen Verbeeck (7/10/2014)
Jack Corbett (7/10/2014)
Koen Verbeeck (7/10/2014)
I saw Jeff was endorsed 9 times for...
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, 2014 at 7:56 am
Interesting question. I have never run into this. I am curious if I will see this at some point in a project requirement.
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, 2014 at 7:46 am
Grant Fritchey (7/9/2014)
GilaMonster (7/9/2014)
Personally I still schedule index rebuilds on all servers. But I schedule targeted ones that rebuild just what needs rebuilding and only larger tables.+1
I mostly agree with...
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 9, 2014 at 12:15 pm
Luis Cazares (7/9/2014)
SQLRNNR (7/9/2014)
Koen Verbeeck (7/9/2014)
GilaMonster (7/9/2014)
WHERE Coalesce(NotNullableColumn,-1) = 0and CategoryID = @CategoryID
Group By CategoryID
......
Imo there is not necessarily something wrong with the group by.
The coalesce on the other hand...
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 9, 2014 at 11:43 am
Koen Verbeeck (7/9/2014)
GilaMonster (7/9/2014)
WHERE Coalesce(NotNullableColumn,-1) = 0and CategoryID = @CategoryID
Group By CategoryID
......
Imo there is not necessarily something wrong with the group by.
The coalesce on the other hand is for people...
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 9, 2014 at 11:27 am
CELKO (7/9/2014)
These shorthands are a bad idea.
I'm gonna agree with that. I don't like seeing shorthand in the code.
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 9, 2014 at 8:45 am
gefilte
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 9, 2014 at 8:30 am
Eirikur Eiriksson (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
...and now the Backups are coming for 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
July 9, 2014 at 8:23 am
Koen Verbeeck (7/9/2014)
SQLRNNR (7/9/2014)
Koen Verbeeck (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
He's being a tad lazy...
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 9, 2014 at 7:55 am
slight mod on Grants
CREATE EVENT SESSION [QueryMetrics] ON SERVER
ADD EVENT sqlserver.rpc_completed(
WHERE ([sqlserver].[equal_i_sql_unicode_string]([sqlserver].[database_name],N'AdventureWorks2012'))),
ADD EVENT sqlserver.sql_batch_completed(
WHERE ([sqlserver].[equal_i_sql_unicode_string]([sqlserver].[database_name],N'AdventureWorks2012'))
AND sqlserver.client_app_name...
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 9, 2014 at 7:53 am
Koen Verbeeck (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
He's being a tad lazy now.
Prior experience with...
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 9, 2014 at 7:46 am
PHYData DBA (7/9/2014)
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 9, 2014 at 7:43 am
Grant Fritchey (7/9/2014)
ChrisM@Work (7/9/2014)
Grant Fritchey (7/9/2014)
Where does my data come from?Well the mommy data and the daddy data loved each other very much so....
Bwahaaaa! I was so tempted to post...
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 9, 2014 at 7:36 am
Eric M Russell (7/9/2014)
That same day, I was talking with another DBA about if he might be interested in creating a presentation for an upcoming SQL Saturday, and his response...
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 9, 2014 at 7:30 am
Ed Wagner (7/9/2014)
BWFC (7/9/2014)
Stuart Davies (7/9/2014)
TomThomson (7/8/2014)
SQLRNNR (7/8/2014)
onionring
Bell
End
Begin
Circle
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 9, 2014 at 7:22 am
Viewing 15 posts - 2,656 through 2,670 (of 19,560 total)