Viewing 15 posts - 481 through 495 (of 832 total)
The two WHERE clauses were different, so the correct answer ought to be "depends on the data"... 😀
July 25, 2011 at 1:15 am
I'm no expert in ASP, but your hint_answer in the ASP code is a different size to the table declaration, and the business_type column isn't represented at all...
July 6, 2011 at 2:45 am
Just out of curiosity, does this need to be a clustered index? A non-clustered index would not require such huge amounts of storage to create...does depend what queries you're running...
July 4, 2011 at 4:20 am
Jeff Moden (7/2/2011)
July 4, 2011 at 4:03 am
Also note that the stated size of the drives (36.4Gb and 72.8Gb) will be calculated using 1Gb = 1000x1000x1000 bytes, because that's what drive manufacturers do, whereas the operating system...
June 30, 2011 at 3:50 am
Ninja's_RGR'us (6/28/2011)
Just my 0.02$... MS decided that 1 GB ram and 4 GB data was what they were prepared to give for free.
10Gb data in SQL Express 2008 R2,...
June 28, 2011 at 7:19 am
I have a 64-bit R2 Express install on my PC here. Just checked it out, and found the following files:
License_SqlBrowser.txt
license_SQLCMD.txt
License_SQLNCLI_ENU.txt (one of these in both Program Files (x86) and in...
June 28, 2011 at 2:24 am
Revenant (6/24/2011)
June 27, 2011 at 1:33 am
Steve Jones - SSC Editor (6/22/2011)
I like plumbers. They seem to do a better job than I do at hooking pipes together
Yeah, but ask them to do a simple reorganisation...
June 23, 2011 at 1:42 am
It's entirely possible they're not actually doing this themselves--it could be being done by the language libraries they're using; I've seen a VB6 application do something very similar when reading...
June 23, 2011 at 1:37 am
I looked at the question, thought, "Surely this is obvious"--went and ran it in SSMS just to be sure I wasn't missing something. It was only when I came here...
June 23, 2011 at 1:06 am
I don't have a problem with this. XP has already gone out of mainstream support, and I'm sure most DBAs would rather people were *not* connecting to vital databases from...
June 23, 2011 at 1:02 am
Ninja's_RGR'us (6/20/2011)
10 GB is for 2008 R2 (confirmed by a failed restore of a 25 GB db with the error : max 10 GB)
And double confirmed by Microsoft's own product...
June 22, 2011 at 6:54 am
3 divisions in 1/100th second is what I said earlier--maybe I'm not being clear. My argument was that the accuracy in both cases is 1/300th of a second, and the...
June 20, 2011 at 6:17 am
But if the Sybase DATETIME is only accurate to 1/300th of a second, it CAN'T be using any old values for the thousandths--0.001 would make no sense because the value...
June 20, 2011 at 2:38 am
Viewing 15 posts - 481 through 495 (of 832 total)