Viewing 15 posts - 2,656 through 2,670 (of 19,564 total)
Koen Verbeeck (7/10/2014)
Jack Corbett (7/10/2014)
Koen Verbeeck (7/10/2014)
I saw Jeff was endorsed 9 times for...
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.
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...
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...
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...
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.
July 9, 2014 at 8:45 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...
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...
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...
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...
July 9, 2014 at 7:46 am
PHYData DBA (7/9/2014)
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...
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...
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
July 9, 2014 at 7:22 am
Viewing 15 posts - 2,656 through 2,670 (of 19,564 total)