Viewing 15 posts - 16,111 through 16,125 (of 49,552 total)
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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
October 15, 2012 at 2:04 pm
sys.partitions or sys.dm_db_partition_stats.
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
October 15, 2012 at 12:47 pm
underwoodmf (10/15/2012)
I'm certain the engine wasn't stopped when the backup ran. Is that a show stopper?
Quite likely.
SQL locks the database files open while it's running. That means that most backup...
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
October 15, 2012 at 12:46 pm
Maybe. As long as you have both files (log and data) and those copies were taken with the database engine stopped then you should just be able to attach them...
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
October 15, 2012 at 12:22 pm
Start with chapter 1
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
October 15, 2012 at 11:25 am
SQL onto a regular domain member, another machine as the DC. It is very strongly recommended not to ever install SQL Server on a domain controller.
p.s. A laptop that's 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
October 15, 2012 at 11:24 am
Memory, CPU and IO subsystem throughput. That's pretty much that.
Take a look a the IO subsystem, I won't be particularly surprised to find that's the bottleneck.
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
October 15, 2012 at 10:49 am
SSMS mistakes. It's not even uncommon. Try Plan Explorer rather.
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
October 15, 2012 at 10:45 am
Because restoring a backup always recreates the database exactly as it was at the time the backup was taken.
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
October 15, 2012 at 10:38 am
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
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
October 15, 2012 at 10:29 am
Even without sharepoint it's an incredibly difficult process (and the bigger the DB the worse it gets). This is definitely one place where prevention (warning messages in sharepoint, training) is...
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
October 15, 2012 at 9:06 am
Um.... With extreme amounts of difficulty. Given that it's sharepoint, even harder.
In a normal, non-sharepoint DB, one option would be something like
Delete the sensitive data (just marks the space as...
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
October 15, 2012 at 8:56 am
'k, so it is as I suspected (and mentioned several posts ago), the spt_values table is not there. Someone must have dropped it at some point for whatever reason.
You will...
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
October 15, 2012 at 8:49 am
Yes, but just within the log backup interval that contains the bulk operations.
p.s. Please post new questions in a new thread in future. Thanks
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
October 15, 2012 at 8:08 am
It's completely valid. It's like saying WHERE 1=1. At worst it'll confuse people reading the code who wonder why it's 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
October 15, 2012 at 6:41 am
Viewing 15 posts - 16,111 through 16,125 (of 49,552 total)