Viewing 15 posts - 9,271 through 9,285 (of 49,552 total)
Time to give devs a training course on SQL admin.
Backup history is in MSDB backuphistory 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
April 16, 2014 at 4:01 pm
Cached plans don't contain the degree of parallelism. If there's a parallel query in cache, it's the query execution engine which decides what DOP to use or whether to discard...
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
April 16, 2014 at 3:31 pm
Break it, no. However to restore you'd need that log backup file.
I can understand devs taking ad-hoc full backups (though they shouldn't have sufficient rights on production to do that),...
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
April 16, 2014 at 2:00 pm
Differential and log backups can run at the same time, there's no problems doing 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
April 16, 2014 at 12:54 pm
Statistics have no dependency on parallelism or lack thereof.
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
April 16, 2014 at 12:52 pm
Full backups do not and never have broken the log chain.
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
April 16, 2014 at 12:51 pm
No conflict.
Maxdop query hint overrides the server Maxdop setting.
If resource governor is enabled and a Maxdop is set via resource governor, then that is the max value allowed. A 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
April 16, 2014 at 12:48 pm
Your suggested index is not a replacement for the other two. It may be good enough for your workload, but you should test carefully.
Part of it will depend on how...
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
April 16, 2014 at 7:47 am
The query is reading just over 14 million rows and aggregating that down to 1099. If it's reading 14 million rows from a table (the rows which satisfy the where...
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
April 16, 2014 at 4:21 am
How many rows total in the table?
You told me earlier that there were 1099 rows which qualified for the where clause, but the plan shows 14 million rows being returned...
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
April 16, 2014 at 3:48 am
I suppose you could loop over each database and query sys.sql_modules. But the Generate Scripts option I mentioned is Management Studio functionality, not a SQL command.
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
April 16, 2014 at 3:24 am
yuvipoy (4/16/2014)
Then why peoples are giving suggestion to have SORT_IN_TEMPDB option.
Because it means that SQL uses TempDB to allocate that temporary work space, not your user database. It means 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
April 16, 2014 at 3:20 am
yuvipoy (4/16/2014)
where does these index will resides if we set SORT_IN_TEMPDB?
In the user database, where indexes always reside.
The Sort in TempDB option changes where SQL allocates temporary work space from,...
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
April 16, 2014 at 3:19 am
Go have a chat with your DBA and ask why the option was changed. It could be a security requirement that it be disabled.
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
April 16, 2014 at 2:56 am
If he's logged in with SQL authentication, the SQL username is all that you can get. If you want to get the windows logins, require people to use windows authentication.
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
April 16, 2014 at 2:50 am
Viewing 15 posts - 9,271 through 9,285 (of 49,552 total)