Viewing 15 posts - 20,611 through 20,625 (of 49,552 total)
Ian Scarlett (2/3/2012)
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 3, 2012 at 5:31 am
Cardinality (in SQL) is used with regards to a query operator in a query. It it simply the measure of how many rows that query operator processes.
So if an index...
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 3, 2012 at 4:25 am
shovankar (2/3/2012)
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 3, 2012 at 4:19 am
No. SQL's backups are full, differential and log.
Some people call log backups incremental, but they are not truly incremental backups
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 3, 2012 at 4:13 am
Restore from a clean backup and check what is wrong with the IO subsystem for it to be throwing that error (something is wrong)
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 3, 2012 at 4:10 am
Revenant (2/2/2012)
SQLRNNR (2/2/2012)
GilaMonster (2/2/2012)
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 3, 2012 at 3:58 am
http://www.google.com/search?q=virtualization+%22SQL+Server%22
I stopped checking after 3 pages of relevant results.
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 2, 2012 at 5:03 pm
That requirement falls under what's called HA/DR - High Availability/Disaster Recovery. Massive topic, entire books have been written on that. Start with Books Online, there are sections for High Availability...
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 2, 2012 at 5:00 pm
Evil Kraig F (2/2/2012)
GilaMonster (2/2/2012)
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 2, 2012 at 3:29 pm
Anyone interested in proof-reading an article on bulk-logged recovery and minimally logged operations? It's titled as an introductory article, but I read the log and might end up with some...
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 2, 2012 at 3:14 pm
I suspect you'd have to declare a table of that type to check the identity properties. The type doesn't have an identity itself, it's just the definition for a table
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 2, 2012 at 3:11 pm
Depends on when the transactions complete. If they commit before the data-copying portion of the backup completes, yes. Otherwise no.
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 2, 2012 at 1:34 pm
Replication, maybe, but it can give problems if you're updating/deleting the data. Also a serious security/data privacy concern. If you're under any of the SOX, HIPAA or similar, that would...
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 2, 2012 at 1:32 pm
The code you posted has syntax errors in it.
Msg 156, Level 15, State 1, Procedure xxxx, Line 54
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure xxxx,...
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 2, 2012 at 11:29 am
That's the count of plans found in cache. Duplicate plans are usually caused by not parameterising queries, not qualifying object names or changing set options. Since you say it's part...
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 2, 2012 at 11:23 am
Viewing 15 posts - 20,611 through 20,625 (of 49,552 total)