Viewing 15 posts - 30,646 through 30,660 (of 49,552 total)
SELECT name AS TableName FROM sys.tables WHERE OBJECTPROPERTY(object_id,'TableHasPrimaryKey') = 0
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
September 16, 2010 at 6:28 am
Bone dry. (Hasn't rained since April/May)
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
September 16, 2010 at 6:23 am
ravisamigo (9/16/2010)
"In SQL Server 2000 you won't be able to take full backup of log shipped database, because this will break 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
September 16, 2010 at 6:18 am
SafeDistance (9/16/2010)
Gail, Will you accept my apology?
Certainly.
I actually was referring to the post saying something like 'do you need another opinion, a confirmation or something else.'
We 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
September 16, 2010 at 6:07 am
homebrew01 (9/16/2010)
Would multiple steps within a batch have the same effect: ?insert into tableA ....
update tableA ...
insert into tableB ....
All run in the same job step (but no explicit transactions)
No....
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
September 16, 2010 at 6:04 am
Dave Ballantyne (9/16/2010)
What Gail showed will work if the "Begin Tran" statement is within the presently executing batch.
What it will show is the last batch executed by a session 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
September 16, 2010 at 5:13 am
Index rebuilds?
So, in this case, would 1 long transaction cause the log to grow despite the backups ?
Yes. The log can only be truncated up til the beginning of 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
September 16, 2010 at 5:10 am
Did you test it? On my 2008 server it's returning exactly what you asked for.
Test: Open 2 management studio windows.
Window 1: Connect to AdventureWorks and run
BEGIN TRANSACTION
UPDATE HumanResources.Employee
SET...
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
September 16, 2010 at 5:01 am
Try the second query that I posted. When I tried that out on my own server, it returned one row with the expected session_id and T-SQL 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
September 16, 2010 at 4:44 am
Also try this one:
SELECT *
FROM sys.dm_tran_session_transactions tst INNER JOIN sys.dm_exec_connections ec ON tst.session_id = ec.session_id
CROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle)
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
September 16, 2010 at 4:38 am
Does this help?
SELECT *
FROM sys.dm_tran_active_transactions tat
INNER JOIN sys.dm_exec_requests er ON tat.transaction_id = er.transaction_id
...
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
September 16, 2010 at 4:25 am
Latest patch level for SQL 2000 is SP4, and lower than SP3 there are some really nasty vulnerabilities
Latest patch level for SQL 2008 is SP1
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
September 16, 2010 at 4:24 am
ravisamigo (9/16/2010)
Can you confirm what will happen in SQLServer 2000 if we schedule full backup during...
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
September 16, 2010 at 3:46 am
Paul White NZ (9/16/2010)
What an odd reaction by Mark Enloe (presumably the OP using a different account).
Don't think it's the bit thread OP. Different phrasing and language constructs
He/she seems to...
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
September 16, 2010 at 3:10 am
If you do as Craig suggests, you'll need to somehow enforce that they can only change their own passwords. Otherwise some mischievous individual can change his colleague's password, the sa...
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
September 16, 2010 at 2:01 am
Viewing 15 posts - 30,646 through 30,660 (of 49,552 total)