Viewing 15 posts - 376 through 390 (of 832 total)
Just tested your code out, Jeff--why does it seem to return a maximum 2048 for the max row size, even in cases where I know the maximum row size of...
March 22, 2012 at 2:46 am
When you mention page file usage, are you checking this out in Task Manager? Because the "PF Usage" field on the Performance tab essentially tells you how much physical memory...
March 22, 2012 at 2:41 am
kapfundestanley (3/22/2012)
March 22, 2012 at 2:25 am
This is one of those questions that I answered randomly because I wanted to see what the answer was...would have been nice to get a slightly more in-depth explanation. Still,...
March 19, 2012 at 2:35 am
There's no inconsistency in formatting using tabs provided you always use them--whether the code gets indented 4 or 8 spaces with a tab is largely irrelevant to its readability. Having...
March 19, 2012 at 2:32 am
I wonder if this was put in to catch the people who answer by just running the script without trying to understand it? Let's hope nobody tried that on a...
March 16, 2012 at 10:23 am
baabhu (3/15/2012)
Is there a way to shrink the tempdb without having the downtime?
No.
March 15, 2012 at 2:47 am
opc.three (3/14/2012)
True, but you can guarantee you are the anyone 😀
How can you guarantee that? Once the database has been restored and you've set it single-user, you're then in a...
March 15, 2012 at 2:39 am
Steve Jones - SSC Editor (3/14/2012)
March 14, 2012 at 8:56 am
I think the difference is, if one of your internal systems goes down for any reason, you're in control of getting it back up and running. If the "cloud" goes...
March 14, 2012 at 2:13 am
Well, it's either that or the mixed case used for Authorization confused them because it doesn't immediately look like a keyword! 🙂
March 13, 2012 at 7:52 am
Several of our clients are still running SQL 2000. I don't have a problem with the database engine at all--the Enterprise Manager/Query Analyzer combo is a pain in the butt,...
March 9, 2012 at 6:54 am
Wasn't the "explanation" more or less a repeat of the question? It really felt like "Is X true? Yes it is, because X is true!". Needed a reference at the...
March 7, 2012 at 1:09 am
Good thing I actually looked up the T-SQL definition of this before answering, because I wasn't sure if it should include the endpoints or not...the actual English word "between" is...
March 5, 2012 at 1:07 am
Pretty sure you don't need TCP/IP to connect to a local SQL installation. Connecting over the network from a remote machine is a different matter.
February 29, 2012 at 6:45 am
Viewing 15 posts - 376 through 390 (of 832 total)