Viewing 15 posts - 6,331 through 6,345 (of 49,571 total)
Steve Jones - SSC Editor (3/27/2015)
March 30, 2015 at 2:53 am
All databases other than Express have a database size limit a little over 500 000 TB. SQL Express has a 10GB limit.
March 30, 2015 at 2:47 am
Christopher Kutsch (3/27/2015)
March 27, 2015 at 9:32 am
Perry Whittle (3/27/2015)
gs1975 (3/27/2015)
We are currently planning a side-by-side SQL Upgrade from 2008r2 to 2014.
One of the post-Upgrade checks I would like to do is to run DBCC CHECKDB WITH...
March 27, 2015 at 5:57 am
Absolutely. After upgrades and regularly as part of your normal maintenance (With Data_Purity is the default, but it's a good idea to specify it on the post-upgrade one)
March 27, 2015 at 3:53 am
Luis Cazares (3/26/2015)
By the way, about the article that Gail posted where they mention a comic book cover. I found that discussion out of place.
Yeah, that protest is stupid.
The...
March 27, 2015 at 3:47 am
Probably neither.
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
March 27, 2015 at 2:49 am
Igor Micev (3/27/2015)
If you're going to play with MAXDOP, the figure I use (based on advice from Adam Machanic) is 1.5*(number of physical cores in a NUMA node).
I'm curious to...
March 27, 2015 at 2:47 am
Definitely backup/restore to move the databases. The backup files aren't affected by whether the server is x86 or x64 (neither are the database files for that matter)
If you have a...
March 26, 2015 at 8:13 am
CXPacket waits are an indication that queries are running in parallel. That's it. It is not by itself indicative of performance problems, it is not by itself indicative of high...
March 26, 2015 at 7:19 am
I don't think you can.
Removing the derived table is easily enough, but then you run into the "No outer joins." limitation. Convert to NOT IN/NOT EXISTS and you run into...
March 26, 2015 at 3:48 am
The ldf file isn't in the backup. All that's in the backup is the data and what was the active portion of the log at the time of backup. If...
March 26, 2015 at 2:43 am
spaghettidba (3/25/2015)
The accusation "man = male chauvinist" is very common, that's why everybody wants to say they're not like that.
Annoyingly so, along with the growing accusation "feminist = man hater"....
March 25, 2015 at 12:43 pm
valeryk2000 (3/25/2015)
Can I right something like that:=============
Insert into table1
exec myProc '1/1/15', 3/1/15'
Yes
March 25, 2015 at 8:00 am
The one that lists root directory, backup directory, data directory, log directory. They're the only things on that screen and it's the default tab, so hard to miss unless you're...
March 25, 2015 at 7:58 am
Viewing 15 posts - 6,331 through 6,345 (of 49,571 total)