Viewing 15 posts - 16,006 through 16,020 (of 49,552 total)
briancampbellmcad (10/19/2012)
IF (SELECT Transaction_Type FROM INSERTED) = 'From Bulk Assignment'
That is a very common mistake in triggers.
If 3 rows are inserted in a single operation, one has a transaction type...
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 19, 2012 at 8:35 am
Windbg. Google it. You also need the public symbols for SQL Server, a good understanding of hex and low-level code and a lot of time and patience.
Honestly, my recommendation stands,...
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 19, 2012 at 5:54 am
You read dump files with a debugger, something like Windbg (also need the symbols files for SQL Server). That said, it's not something that's easy to understand.
If it was SQL...
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 19, 2012 at 5:40 am
A once-off shrink (followed by index rebuilds) is not a problem. Just don't automate and schedule the shrinks.
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 19, 2012 at 5:37 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1374671-1281-1.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 19, 2012 at 3:19 am
Profiler (SQL Trace) or extended events. The method given by that blog is not complete. It only catches queries whose plans get cached.
If your logging just has to be close...
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 18, 2012 at 5:24 pm
Sounds like you want a NOT EXISTS or NOT IN.
SELECT <stuff> FROM Table WHERE NOT EXISTS (SELECT 1 FROM AnotherTable WHERE Table.JoinColumn = AnotherTable.JoinColumn)
SELECT <stuff> FROM Table WHERE Table.JoinColumn NOT...
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 18, 2012 at 3:36 pm
Ivan Mohapatra (10/18/2012)
if it is not useful then why ?
1) Because it is ignored for the target of update statements (changes always have to take exclusive locks)
2) Because it allows...
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 18, 2012 at 3:06 pm
If you do go that route, you get 3 things for the price of 1, you get to test your restores and ensure that they really do restore, you get...
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 18, 2012 at 1:56 pm
Perhaps just restore your daily backup every night?
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 18, 2012 at 1:04 pm
Why don't you just have the one trigger that populates bulk transactions and then does the necessary updates? Honestly. I don't understand what you're trying to do here.
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 18, 2012 at 11:31 am
Log shipping or transactional replication?
Log shipping doesn't use a distributor, just the normal log backups that you'll be taking already
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 18, 2012 at 11:28 am
So people with the same name never share a birthday?
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 18, 2012 at 10:47 am
HowardW (10/18/2012)
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 18, 2012 at 10:21 am
bugg (10/18/2012)
There is 1 database, so yes its mission critical this thing hums all year round.
Mission critical as in 24/7/365, if the DB goes down for a few hours...
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 18, 2012 at 10:16 am
Viewing 15 posts - 16,006 through 16,020 (of 49,552 total)