Viewing 15 posts - 1,951 through 1,965 (of 49,552 total)
You can't restore up-version and leave the DB in standby and be able to restore further logs. You'll have to restore WITH NORECOVERY. With that change, your plan will work.
You've...
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
January 3, 2017 at 6:58 am
msbikk (12/28/2016)
I am currently working on the idea to move my on-premise data warehouse to Azure SQL Data Warehouse.
Not directly answering the question, but Azure SQLDW is not just 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
January 3, 2017 at 6:32 am
A uniqueidentifier isn't ideal for a clustered index (search term: fragmentation), but it's not all that likely that it's the root cause of the deadlocks.
Stop using the 1204 traceflag, that's...
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
January 3, 2017 at 5:34 am
Pages can be read multiple times. If a page is read 5 times during a query's processing, that's 5 logical reads.
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
January 3, 2017 at 5:07 am
Index on foreign keys is a good place to start, but it may not be the best index to have. It's only really needed if rows in the parent 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
January 3, 2017 at 2:17 am
Where are you getting that error from? It doesn't look like a SQL server error message.
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
December 23, 2016 at 3:14 am
It would probably be something doing a scan of a large table. Look at execution plans for table scan/index scan.
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
December 23, 2016 at 3:01 am
Go to 16.
Upgrading to SQL 2014 is the same work as upgrading to 16, and leaves you with an older version, fewer features and less time before it's out of...
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
December 23, 2016 at 2:59 am
Please note: 4 year old post
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
December 22, 2016 at 5:14 am
kevaburg (12/22/2016)
it is likely indicative of an impending hardware failure....
Not necessarily. It could be anything in the IO stack from buggy filter drives to faulty cables, faulty switch, problems with...
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
December 22, 2016 at 4:48 am
Clean installs are always preferred. Easier to revert back if anything goes wrong to start.
On the 2012-2014 side, you MUST test before you do that upgrade. One of the changes...
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
December 22, 2016 at 2:32 am
Tbh, don't bother calling Microsoft. They'll tell you to restore your last good backup. They won't help with data recovery (not allowed to) and probably won't be much more help...
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
December 22, 2016 at 2:29 am
You would restore the full, the latest differential (not all of them) and all log backups after that (leaving the DB in the RESTORING state), then set up the log...
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
December 20, 2016 at 7:47 am
Thom A (12/20/2016)
GilaMonster (12/20/2016)
The answers in the last two posts will work fine, but they have an inherent performance problem. Have a look at the first section of https://www.simple-talk.com/content/article.aspx?article=2280
Getting 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
December 20, 2016 at 7:32 am
Siberian Khatru (12/20/2016)
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
December 20, 2016 at 7:29 am
Viewing 15 posts - 1,951 through 1,965 (of 49,552 total)