Viewing 15 posts - 6,331 through 6,345 (of 49,552 total)
Steve Jones - SSC Editor (3/27/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 30, 2015 at 2:47 am
Christopher Kutsch (3/27/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 27, 2015 at 3:47 am
Probably neither.
http://www.sqlservercentral.com/articles/Recovery+Model/89664/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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"....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 25, 2015 at 7:58 am
Viewing 15 posts - 6,331 through 6,345 (of 49,552 total)