Viewing 15 posts - 2,791 through 2,805 (of 49,552 total)
dbomgard (7/18/2016)
GilaMonster (7/17/2016)
First thing, alert the owners of this DB that they've likely lost significant amounts of data, possibly everything, and repairs will take a few days at best,...
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
July 19, 2016 at 1:59 am
If you drop an offline database the files aren't deleted.
You don't need to restart the instance. If it is the case that the DB was offline when dropped, you just...
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
July 18, 2016 at 7:15 am
rathimittha.mb (7/18/2016)
Wouldn't it be better to just select the required 5 and then join with any other table??
No. It's better to write your query as simply as you can.
SELECT t1.col1,...
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
July 18, 2016 at 6:04 am
rathimittha.mb (7/18/2016)
Also, under what conditions would I use UPDATE STATISTICS ?? I assumed it was right to use in the current situation of mine
When the statistics are 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
July 18, 2016 at 5:57 am
rathimittha.mb (7/18/2016)
My intention is to use a single query for both the cases. And that's why the usage of 'case'
'Generic' queries such as that are typically slow. I think...
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
July 18, 2016 at 5:31 am
It does help if you post the actual query...
Add OPTION(RECOMPILE) to the end if the query and test again. The case statements as they are ensure that the optimiser cannot...
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
July 18, 2016 at 4:01 am
Table definitions, index definitions and execution plan please.
What exactly is AND 1=(Case when 1 = 0 then 1 When 1 = 1 and fca.isactive = 1 then 1 END )...
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
July 18, 2016 at 2:36 am
johnwalker10 (7/18/2016)
> Use DBCC PAGE to try to figure out which tables in the database are affected and drop their...
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
July 18, 2016 at 12:45 am
muthukkumaran Kaliyamoorthy (7/18/2016)
What i understand from the errors, either can be restored from backup or repair_allow_data_loss.
Yup.
If the minimum level to repair is repair_allow_data_loss then repair_rebuild is just a waste 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
July 18, 2016 at 12:42 am
Wonderful.
First thing, alert the owners of this DB that they've likely lost significant amounts of data, possibly everything, and repairs will take a few days at best, if there'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
July 17, 2016 at 11:00 am
Sure. Set up Extended events with the relevant events. Blocked process report if you have it configured, or you could use the wait-related events if carefully filtered, and the deadlock_info...
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
July 16, 2016 at 8:48 am
Restore should (almost) always be your first choice, so if you have good backups and can restore, do so.
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
July 16, 2016 at 8:47 am
dbomgard (7/15/2016)
I'm still receiving the errors (below).. will someone please point me in the right direction?
Restore from your last good backup.
Repair is not the first thing that should be tried....
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
July 16, 2016 at 8:42 am
Any login (Windows or SQL) which is a member of the sysadmin fixed server role has all permissions and cannot be denied anything (basically SQL doesn't do permissions checks for...
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
July 15, 2016 at 9:36 am
As soon as either of the READ_COMMITTED_SNAPSHOT or ALLOW_SNAPSHOT_ISOLATION_LEVEL database options are enabled, data modifications write their old versions to TempDB, no matter what else is running at the 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
July 15, 2016 at 7:42 am
Viewing 15 posts - 2,791 through 2,805 (of 49,552 total)