Viewing 15 posts - 1 through 15 (of 237 total)
July 11, 2017 at 3:57 am
And the elephant in the room (or is it a donkey)? I really like that everyone has completely avoided answering your implied question about political leanings. It could easily devolve...
July 10, 2017 at 7:43 pm
Jeff Moden (12/26/2016)
Sioban Krzywicki (12/21/2016)
December 28, 2016 at 2:14 pm
When you said there's a 6 or 10 hour delay, the first thing that came to mind was maybe the time on your report services server is not the time...
December 20, 2016 at 2:21 am
MMartin1 (11/10/2016)
...CounterpartyAccountKey and GenevaAccountKey ..
If these do represent the source, think of the maintenance nightmare when the source changes, or another is added. This is not the way to design...
November 11, 2016 at 1:53 am
Interesting to know that sparse columns aren't compressible. Thanks for the question.
My first thought was "every datatype"? Wow. Does that include every variation of datatype like char(1)...char(8000) . I realise...
September 5, 2016 at 3:56 am
David.Poole (8/30/2016)
Indianrock (8/30/2016)
Another example of the problem is a 4GB plan cache with 2,500 single-use plans out of a total of about 12,000 plans. The ORM sets parameter character...
August 30, 2016 at 9:57 am
Aaron N. Cutshall (8/30/2016)
August 30, 2016 at 9:44 am
Sean Redmond (8/30/2016)
Here is (if I remember...
August 30, 2016 at 9:21 am
Aaron N. Cutshall (8/30/2016)
Ralph Hightower (8/30/2016)
Switching the patient lookup to a stored procedure increased the performance of that phase of the application by 25%.
Ralph, it's all in how the stored...
August 30, 2016 at 8:47 am
I've worked with many different reporting tools including SSRS, and they all try and hide the SQL away and encourage you to do grouping and calculations within the report. The...
August 23, 2016 at 8:48 am
simon.dobner 32307 (5/4/2014)
OK, Thanks, got it now.'Input' is not necessarily the same as 'table in the from clause'
Regards
Simon
This is a great article, and I think this question in the comments...
May 18, 2016 at 8:19 am
Thanks for the question. Never used the str() function.
How very strange that it would return a left padded string of default length 10 given BOL says its return type is...
July 2, 2015 at 7:30 am
Good question. I dislike the inconsistency with the syntax. You should always have to specify the keyword COLUMN. It makes it more self explanatory. Having to memorize idiosyncrasies of syntax...
June 17, 2015 at 6:41 am
omarlopez7 (3/6/2015)
In that case not work, i says if you us on the where section like this.Select * from table
where date between '12-12-12' and '12-31-12'
Between is inclusive of the start...
March 6, 2015 at 6:26 am
Viewing 15 posts - 1 through 15 (of 237 total)