Viewing 15 posts - 46 through 60 (of 231 total)
I'm passing a local variable as the parameter and the variable datatype is Int64. The source datatype is a NUMERIC (8,0) but, in practice, the value will never exceed...
April 14, 2014 at 9:56 am
I tried the MIN thing and it wasn't doing what I wanted because there were some empty strings rather than NULLS in the data but when I changed it to...
April 3, 2014 at 2:42 pm
We have been told that the problem with reports with parameter lists is a KNOWN bug and Microsoft is working on it. So, if you install CU4, keep an...
June 12, 2013 at 6:29 am
I'm using SQL Server 2012 Integration Services Design Patterns by Andy Leonard, Matt Masson et al. I've found it very useful. I'm also using Professional Microsoft SQL Server...
June 7, 2013 at 11:57 am
As has already been stated, the answer is "it depends". That being said there are some guidelines.
RAID 5 write performance is very poor compared to RAID 10 due to...
May 6, 2011 at 9:35 am
Doing some catching up on past QOD's and I don't understand how the number 16 was arrived at. The question was about creating a new transaction log not extending one....
January 19, 2011 at 8:54 am
Thanks for putting this together. It was a fascinating exercise that I really enjoyed. Like many others I have struggled to find a genuine use case for this...
December 29, 2010 at 5:41 am
If you look at the query plan for just the query run separately you'll see that the missing index doesn't appear. That table isn't referenced by that query. ...
December 23, 2010 at 6:04 am
I forgot to mention this but I did update (with fullscan) the statistics for every table referenced in the query prior to the tests.
December 22, 2010 at 2:24 pm
For anyone paying attention the issue is resolved. I uninstalled SQL Server 2008, made myself an admin on the box and re-installed SQL Server 2008. Suddenly everything was...
December 9, 2010 at 7:53 am
Unfortunately, it's prompting me for a password and I don't know the password for the administrator account. (I'm running XP) I'm not sure that would help me much...
December 8, 2010 at 12:30 pm
David Portas (11/4/2010)
ta.bu.shi.da.yu (11/4/2010)
Still trying to see what desirable qualities that natural keys have. Could you point out some examples?
A natural key enforces a data integrity rule that stops some...
November 4, 2010 at 9:08 am
ta.bu.shi.da.yu (11/4/2010)
Michael Ebaya (11/4/2010)
ta.bu.shi.da.yu (11/4/2010)
I am really curious to know why it's a good idea to not enforce the immutability of the key!
This has already been covered in excruciating detail....
November 4, 2010 at 8:57 am
ebaya (10/27/2010)
Robert Frasca (10/27/2010)
Since when? With all due respect that's pretty much a nonsensical statement. What difference does it make whether it's a new schema or an existing...
October 27, 2010 at 9:20 am
ebaya (10/26/2010)
Robert Frasca (10/26/2010)
Tables are the product of normalization.
True-- when starting from a clean slate. In practice, the word "normalization" has come to mean aligning an existing schema with...
October 27, 2010 at 7:49 am
Viewing 15 posts - 46 through 60 (of 231 total)