Viewing 15 posts - 14,326 through 14,340 (of 49,552 total)
Please take the language and the random insults elsewhere, they have no place on a professional forum.
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
February 11, 2013 at 8:33 am
Vedran Kesegic (2/11/2013)
No phantoms are possible, so it is a very good thing, and is on by default on most of my productions.
Phantoms are indeed possible under read committed snapshot,...
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
February 11, 2013 at 7:13 am
sotn (2/11/2013)
The full backup at 10:00 contains transactions since the last full backup
The full backup contains the complete state of the database at the time of backup, it's not 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
February 11, 2013 at 6:09 am
Looks like all errors were fixed. Now sort out your backup strategy.
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
February 11, 2013 at 6:08 am
Err... think about whether the first option is even feasible. Imagine a 2TB database with 100 transactions/sec....
http://msdn.microsoft.com/en-us/library/ms345124%28v=sql.90%29.aspx
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
February 11, 2013 at 6:07 am
Geoff Clark (2/11/2013)
But at the very least it is misleading, MCM SQL 2008 is top of the list of those that require the recertification.
MCM (or what it's being converted...
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
February 11, 2013 at 6:00 am
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
February 11, 2013 at 12:57 am
Perfectly normal. SQL will use as much memory as it can, up to the configured max server memory. If SQL's using too much memory, drop max server memory slightly.
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
February 11, 2013 at 12:12 am
Rum a load test of your app, see how large TempDB gets. Set default size to slightly larger.
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
February 10, 2013 at 2:35 pm
meridius10 (2/10/2013)
OK, so on my CV/resume, would I put T-SQL and SQL in the section for knowledge of programming languages or just T-SQL?
If you came to me with that on...
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
February 10, 2013 at 6:38 am
Buggy network driver, something broken somewhere on the network or a hack attempt.
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
February 10, 2013 at 12:54 am
SQL Kiwi (2/9/2013)
The example was also carefully crafted to use a very small number of rows and unhelpful nonclustered indexes.
I've seen a few articles on that SQL site like that,...
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
February 10, 2013 at 12:50 am
May I suggest normalising the tables? As long as there are comma-delimited keys that's going to be hell to write queries against and will likely have horrid performance problems.
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
February 10, 2013 at 12:47 am
I'd suggest doing that in application code, not database code. They're more designed for that kind of work.
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
February 9, 2013 at 3:25 pm
That is going to be incredibly inefficient. What are you trying to do there?
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
February 9, 2013 at 3:22 pm
Viewing 15 posts - 14,326 through 14,340 (of 49,552 total)