Viewing 15 posts - 6,001 through 6,015 (of 49,552 total)
It'll work fine too.
Take a final log backup before you start the restore. Backup log ... with norecovery. Also take a full backup, just in case. You'll probably have...
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
May 8, 2015 at 9:02 am
Cool.
Looking at that again, your plan of dropping (or truncating) the table and then reloading will work. You'll have to drop foreign keys and disable the trigger before truncating it...
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
May 8, 2015 at 8:20 am
Before you do anything, please run the following and post the full, complete, unedited output
DBCC CheckDB('<database name>') WITH NO_INFOMSGS, ALL_ERRORMSGS
Probably, if you have the time, best fix will be 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
May 8, 2015 at 7:39 am
xsevensinzx (5/8/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
May 8, 2015 at 7:01 am
xsevensinzx (5/8/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
May 8, 2015 at 6:30 am
SQL doesn't keep track of insert or deletion rates, so you'll need a trigger on the table or something like Change Data Capture or Change Tracking to do this.
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
May 8, 2015 at 6:27 am
Structure your query as a select first. It's easier to debug.
SELECT
CASE
WHEN EA.DataSet = 'Abstract' THEN EA.BufferedArea_km2
ELSE 999
END as AbstractArea,
CASE EA.DataSet WHEN 'discharges' THEN EA.BufferedArea_km2
END as Discharge_Area
FROM #TEMP1 T
INNER JOIN Royalties.dbo.RoyaltyActuals...
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
May 8, 2015 at 6:16 am
Igor Micev (5/8/2015)
This article is very good - http://www.mssqltips.com/sqlservertip/1254/clustered-tables-vs-heap-tables/
Primary key != clustered index.
A table can be a heap and have a primary key
A table may have a clustered index but...
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
May 8, 2015 at 5:57 am
Please post new questions in a new thread. Thank you
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
May 8, 2015 at 2:58 am
charipg (5/7/2015)
Need a script to create a new role in all databases to cover SP creation/execution, any table data manipulation (insert, update, delete & select) .
Google search topics:
"CREATE ROLE...
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
May 8, 2015 at 2:54 am
Lynn Pettis (5/7/2015)
I really want to say "Write it yourself. We aren't here to do your work for you."
For a couple seconds I thought that was directed at me...
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
May 8, 2015 at 2:53 am
Again, MAXDOP does not control the number of threads in total. It controls the number of threads that may be concurrently *running* for a single query.
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
May 8, 2015 at 2:52 am
Brent Ozar (5/7/2015)
The only feature they've announced (this week) is a subset of AlwaysOn Availability Groups in Standard Edition, basically replacing database mirroring, which has been deprecated.
And about bloody time...
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
May 7, 2015 at 3:24 pm
spaghettidba (5/7/2015)
GilaMonster (5/7/2015)
Ok, I need to write something.Article requests?
"How centralized backup tools promise the moon and don't deliver"
Hmm, ok, now I see how this topic helps making friends at ISVs...
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
May 7, 2015 at 2:50 pm
That's not an article, that's a small book.
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
May 7, 2015 at 2:06 pm
Viewing 15 posts - 6,001 through 6,015 (of 49,552 total)