Viewing 15 posts - 6,001 through 6,015 (of 49,571 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...
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...
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...
May 8, 2015 at 7:39 am
xsevensinzx (5/8/2015)
May 8, 2015 at 7:01 am
xsevensinzx (5/8/2015)
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.
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...
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...
May 8, 2015 at 5:57 am
Please post new questions in a new thread. Thank you
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...
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...
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.
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...
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...
May 7, 2015 at 2:50 pm
That's not an article, that's a small book.
May 7, 2015 at 2:06 pm
Viewing 15 posts - 6,001 through 6,015 (of 49,571 total)