Viewing 15 posts - 13,666 through 13,680 (of 49,552 total)
Lynn Pettis (3/29/2013)
The only overhead not involved is the recovery process when SQL Server starts up.
Not quite, there is less logging overhead on data modifications. TempDB is optimised for lots...
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
March 29, 2013 at 5:11 pm
Lynn Pettis (3/29/2013)
The advantage to tempdb is that there is less overhead writing data there since SQL "knows" it never has to recover tempdb.
OMG!...
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
March 29, 2013 at 5:09 pm
sqldba_newbie (3/29/2013)
Within Confio (Ignite) and also when i run manually, i can see the plan handles are different.
Can't help you with just that info. There's a lot of things 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
March 29, 2013 at 5:02 pm
sqldba_newbie (3/29/2013)
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
March 29, 2013 at 1:19 pm
The alternative for shinking is to move objects to a second filegroup and drop the original filegroup. However you can't do that because the original filegroup is primary and primary...
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
March 29, 2013 at 8:08 am
santhosh_ms3 (3/29/2013)
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
March 29, 2013 at 7:23 am
deepkt (3/29/2013)
Try this:SELECT TOP 3 EMPID FROM EmpTable
UNION ALL
(
SELECT EMPID FROM EmpTable
EXCEPT
SELECT TOP 3 EMPID FROM EmpTable
)
Top without order by = inconsistent results. With that, SQL will give...
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
March 29, 2013 at 7:22 am
Hemant.R (3/29/2013)
As mention ,log file extension idf .Database is accessible but in case of attach detach process it might create problem .
It won't create any problems at any 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
March 29, 2013 at 5:13 am
Loundy (3/28/2013)
I'm not sure what type of stats update would be necessary here - probably a full scan.
None. Shrinking a DB doesn't affect the stats so there's no need...
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
March 28, 2013 at 3:12 pm
Before you go and harm your databases with this, please take a read through this - Managing Transaction Logs[/url]
I'm going to guess you have no log backups and hence 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
March 28, 2013 at 1:37 pm
Sure, look it up on the server properties window, in sys.configurations or sp_configure.
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
March 28, 2013 at 11:17 am
Ness (3/28/2013)
There is also the sys.dm_tran_locks DMV
That doesn't show deadlocks. It shows granted and waiting locks. There's no DMV that shows deadlock info
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
March 28, 2013 at 11:11 am
The traceflag 1222 (don't use 1204, it's SQL 2000 and before). Extended events system health session too it runs automatically so all you need to do there is query it.
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
March 28, 2013 at 11:10 am
sqlfriends (3/28/2013)
ganasulochana (3/28/2013)
If the database is in Full recovery model then you can able to take the log backup.for simple recovery mode, when it will do the checkpoints?
Checkpoint runs on...
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
March 28, 2013 at 11:07 am
Restore it.
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
March 28, 2013 at 9:08 am
Viewing 15 posts - 13,666 through 13,680 (of 49,552 total)