Viewing 15 posts - 4,411 through 4,425 (of 49,552 total)
Nothing wrong with SQL Server here, it's starting up fine.
2015-10-26 18:40:40.64 spid10s SQL Server is now ready for client connections. This is an informational message; no user action is required.
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
October 27, 2015 at 11:28 am
Post the error log please, 19456 is, iirc, a SQL login failure and so probably irrelevant.
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 26, 2015 at 10:43 pm
There's about a thousand possible causes.
Locate the latest error log, go to the end of the file and look for error messages. SQL is very, very good about logging 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
October 26, 2015 at 5:04 pm
chris92mars (10/25/2015)
Can I know on what scenario, the disable trigger will be enable again.
Someone ran ALTER TRIGGER ... ENABLE
It should be caught in the default trace, along with the username,...
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 26, 2015 at 4:38 pm
If there's only one order with that value, the delete would have deleted one row. SQL would have implicitly converted the string column to int to do the comparison.
Did 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
October 24, 2015 at 4:03 am
Somewhere between Oct 1 and Oct 23, one or more log backups have been taken, or the db has been switched to simple recovery and back to full.
Either one would...
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 24, 2015 at 3:55 am
The hidden system tables are not documented in any way, and you probably shouldn't be using them. Use the documented system views and DMVs instead.
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 24, 2015 at 3:52 am
A full backup is a copy of the database as it was at the time of backup. It can be restored ONLY to the time of the backup.
To do point-in-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
October 23, 2015 at 5:53 am
Yes.
It doesn't truncate the log, only log backups do that (in full/bulk-logged), but full backups do back up a portion of the log. If they didn't, it would not be...
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 23, 2015 at 5:49 am
Yes.
Hekaton is actually less about the 'in-memory' and more about the way the rows are stored, the complete lack of locking and latching and the optimised access path.
That said, it'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
October 23, 2015 at 5:45 am
Should be some in Books Online. Have a read through the docs on full, diff and log backups and how they work.
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 23, 2015 at 4:20 am
Read up on the GRANT command.
https://msdn.microsoft.com/en-us/library/ms187965.aspx
https://msdn.microsoft.com/en-us/library/ms188371.aspx
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 23, 2015 at 4:11 am
Jayanth_Kurup (10/23/2015)
why do we have multiple files for tempdb ?? one per CPU core ??
If someone has one CPU per core, it's because they don't understand what they're doing....
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 23, 2015 at 3:47 am
It's a hidden system table, so it's not directly for use (it can't even be queried). Rather use the system views like sys.partitions, sys.allocation_units and DMVs like sys.dm_db_partition_stats for such...
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 23, 2015 at 3:32 am
The transactions after the full backup would have flipped the relevant bits in the Differential Change Map, flagging the affected extents as ones which need to be included in differential...
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 23, 2015 at 3:26 am
Viewing 15 posts - 4,411 through 4,425 (of 49,552 total)