Viewing 15 posts - 4,531 through 4,545 (of 49,552 total)
Go to the computer named MIPRD, open Task Manager and look for PID 15844 (assuming the app is still running)
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
October 13, 2015 at 2:43 am
Table definitions, index definitions and execution plan please.
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
October 13, 2015 at 2:40 am
Run the installer, select the option to change or remove features, follow the dialogs. Make sure you select the correct instance to remove.
You can back up the master database. Providing...
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
October 12, 2015 at 9:34 am
GilaMonster (10/12/2015)
it is tied to its source database and cannot be moved anywhere, cannot be backed up, cannot be detached and is meaningless without its source database.
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
October 12, 2015 at 9:28 am
Most DDL can't be parameterised. The way to do this is your original statement.
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
October 12, 2015 at 9:16 am
DECLARE @sSQL NVarchar(4000) = ''
SELECT @sSQL = @sSQL + 'ALTER LOGIN ' + '[' + name + '] ' + ' WITH CHECK_EXPIRATION = OFF; '
FROM sys.sql_logins
WHERE is_policy_checked = 1
...
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
October 12, 2015 at 8:51 am
Yes.
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
October 12, 2015 at 7:36 am
How am I supposed to give you the results you want when the data you provide couldn't possibly generate those results? I can't read your mind, I can't see your...
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
October 12, 2015 at 7:03 am
Where does this row come from?
2015-10-11,null,null,null,46800,50400
The only mission which Ali has with those times has a date of '2015-09-11', so why does it end up in the expected results 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
October 12, 2015 at 6:34 am
Ok, but your required results you say
from 2015-10-04 to 2015-10-11 for john
There's no John in your sample data.
Please ensure that the sample data is correct for the expected results...
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
October 12, 2015 at 6:20 am
Table definitions as CREATE TABLE statements please, and some sample data in the form of INSERT statements. Please ensure that the sample data is correct for the expected results 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
October 12, 2015 at 4:16 am
nadersam (10/12/2015)
GilaMonster (10/12/2015)
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
October 12, 2015 at 4:11 am
vmit02 (10/11/2015)
The backups are occurring every 15 minutes but note that the last two listed have a gap in the LSNs even though they are consecutive backups.
Either you've misplaced 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
October 12, 2015 at 3:26 am
Jeff suggested temp tables. Be careful with table variables, because they don't have statistics, the row estimations are miles off usually and they can (and do) result in really bad...
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
October 12, 2015 at 3:24 am
I think that requires an uninstall-reinstall
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
October 12, 2015 at 2:47 am
Viewing 15 posts - 4,531 through 4,545 (of 49,552 total)