Viewing 15 posts - 556 through 570 (of 49,552 total)
Yup. Lots of ways.
Extended events, SQL Audit, DDL triggers are just some of the options
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, 2017 at 4:07 am
I'd start by looking for jobs that run every hour, starting at 00:45. Shouldn't be a lot of 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
December 21, 2017 at 2:58 pm
Yes.
You probably want to use EXISTS and/or NOT EXISTS. Since you have to check multiple rows for each row, doing this needs a subquery. One used with either...
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 21, 2017 at 2:52 pm
adisql - Thursday, December 21, 2017 2:42 PMits returned data. and we are trying to find how those objects modified .
Yes, 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
December 21, 2017 at 2:47 pm
adisql - Thursday, December 21, 2017 2:37 PMdefault trace is enabled.
Well, obviously it is, or the report you mentioned above would 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
December 21, 2017 at 2:38 pm
You probably want to use EXISTS and/or NOT EXISTS
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 21, 2017 at 2:36 pm
Lynn Pettis - Thursday, December 21, 2017 2:22 PM
Bet coffee that he's looking at the wrong...
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 21, 2017 at 2:35 pm
Default trace doesn't go back far. It's not a full history.
Still, SQL doesn't revert changes. If the objects are an older version, either someone reverted them, or you're...
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 21, 2017 at 2:32 pm
You can't fix that.
If you do recover the DB and run checkDB, you can't get it back into restoring state, and without running checkDB, it won't come out...
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 21, 2017 at 2:28 pm
Either the database was restored to an earlier version, or someone ran ALTER scripts (or DROP & CREATE) on all of the affected objects.
Check restore history, check the...
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 21, 2017 at 2:26 pm
You can do a dynamic sort without dynamic SQL. Not going to be fast, but that's the price you pay for such code.
ORDER BY
CASE @Ordering WHEN...
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 21, 2017 at 2:24 pm
The distinct is still completely unnecessary, as there is no way whatsoever that a TOP(1) could return duplicate rows.
That said, removing the DISTINCT will not change the query'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
December 21, 2017 at 2:22 pm
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 21, 2017 at 1:45 am
SQL Server: Transactions\Transactions/sec, then select TempDB only.
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, 2017 at 8:38 am
The key indicator that it's not an error from SQL Server is that it's a .net exception. SQL Server is not written in .net, and won't throw .net exceptions
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, 2017 at 5:13 am
Viewing 15 posts - 556 through 570 (of 49,552 total)