Viewing 15 posts - 17,656 through 17,670 (of 49,552 total)
If you have no backups then you very likely have lost any data that was in those tables. There are no magic recovery tricks, if the tables are gone, they'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
July 13, 2012 at 3:02 am
Check the exam details on the MSL site, check the skills breakdown, make sure you know the material
http://www.microsoft.com/learning/en/us/certification/cert-sql-server.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
July 13, 2012 at 3:01 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1329298-1550-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
July 13, 2012 at 2:54 am
SQLRNNR (7/12/2012)
GilaMonster (7/12/2012)
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
In most cases. Though...
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
July 12, 2012 at 3:40 pm
Rogman (7/12/2012)
GilaMonster (7/12/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
July 12, 2012 at 3:26 pm
@SQLFRNDZ (7/12/2012)
Ther must be an open transaction that is filling your log, DBCC opentran.
If there was, log_reuse_wait_desc would have returned "Open Transaction", not nothing.
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
July 12, 2012 at 3:21 pm
The point's over there ->
Re: deprecating the old style of joins, ie joining in the where clause. Cannot be easily done.
I'm not endorsing old style joins. I'm saying they cannot...
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
July 12, 2012 at 2:47 pm
Between's fine, but requires more complex date maths and if someone were to change the data type from datetime to datetime or to change the precision of the datetime2, 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
July 12, 2012 at 2:44 pm
Saggy (7/12/2012)
2012-07-11 09:31:37.78 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.
No error. Someone stopped the service.
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
July 12, 2012 at 2:40 pm
If it's a test system then leave it in simple recovery. Have a daily job that sets all DBs to simple recovery. Set it back to full and you'll 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
July 12, 2012 at 2:39 pm
And hence joins in the where clause become
SELECT <stuff>
FROM t1 CROSS JOIN t2
WHERE t1.ID = t2.OtherID
The point is that joins in the where cannot be deprecated without a substantial rewrite...
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
July 12, 2012 at 2:30 pm
SQLSACT (7/12/2012)
GilaMonster (7/12/2012)
Given it's name, what do you think? "waiting tasks"Also, what does Books Online say?
Apologies
I realised the mootness of the question the moment I hit "Post Quoted Reply"
Thanks
🙂
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
July 12, 2012 at 12:28 pm
Jan Van der Eecken (7/12/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
July 12, 2012 at 12:27 pm
Given it's name, what do you think? "waiting tasks"
Also, what does Books Online say?
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
July 12, 2012 at 9:12 am
From os_wait_stats, no, that's the aggregated totals since SQL started.
For process level, sys.dm_os_waiting_tasks or extended events
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
July 12, 2012 at 8:39 am
Viewing 15 posts - 17,656 through 17,670 (of 49,552 total)