Viewing 15 posts - 19,771 through 19,785 (of 49,552 total)
Probably like this
Select
bh.bAuto_Load_Tables As Business_History
, er.bAuto_Load_Tables As Emp_Resr
, fr.tbl_db_info.bAuto_Load_Tables As Fld_Req
, pa.bAuto_Load_Tables As Prj_Accnting
, pf.bAuto_Load_Tables As Prefab
, pm.bAuto_Load_Tables As Prj_Mngt
, EntryInfo.bAuto_Load_Tables As TC_Entry
, ReviewInfo.bAuto_Load_Tables As TC_Review
From
Business_History.dbo.tbl_db_info AS bh
Cross...
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 14, 2012 at 6:46 am
The ALTER DATABASE statement doesn't take variables, nothing more I can say, the syntax rules don't permit it.
This fails with an error
DECLARE @DBName sysname = 'Testing'
ALTER DATABASE @DBName SET RECOVERY...
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 14, 2012 at 6:41 am
simon4132-806507 (3/14/2012)
The cache must empty when failover occurs as queries take ages to run for a couple of minutes until the cache is repopulated.
The data cache shouldn't be completely empty....
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 14, 2012 at 6:40 am
Not following. Please be specific about questions, I can't read your mind.
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 14, 2012 at 6:35 am
simon4132-806507 (3/14/2012)
Is it ok to run DBCC DROPCLEANBUFFERS on the principle?
No, it's recommended that not be run on production
Or will it some how crash the mirror group/ruin the database/cause everything...
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 14, 2012 at 2:45 am
Let me amend that.
Create a clustered index on the WebProxyLog table, key column = logdate.
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 14, 2012 at 2:40 am
Are there any rows in the table that have an ODate of '03/10/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
March 14, 2012 at 2:39 am
Create an index on WebProxyLog. key columns: logTime, ClientIP. Include columns bytesrecvd, bytessent
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 14, 2012 at 2:22 am
We're not going to do your homework for you.
Show what you've tried. Where specifically are you stuck?
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 14, 2012 at 2:20 am
Draelith (3/13/2012)
My issue now is I still don't understand when the log file is actually shrunk in size when the database is in Full recovery mode.
They shouldn't be regularly...
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 14, 2012 at 1:29 am
opc.three (3/13/2012)
2.54 is a number I recognize. Are you by any chance on a 32-bit OS with the /3GB switch enabled but without AWE enabled?
32 bit with /3GB and AWE...
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 13, 2012 at 4:56 pm
No.
From Books Online:
Starting with SQL Server 2000, setting the trunc. log on chkpt. option to true sets the recovery model of the database to SIMPLE. Setting the option to false...
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 13, 2012 at 4:48 pm
Generally this happens because the index has multiple levels and when index physical stats is run with the detailed option it returns one row for each level of the index.
Include...
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 13, 2012 at 4:05 pm
Steve Jones - SSC Editor (3/13/2012)
I'd like to think that we aren't "parenting" newbies like this: http://online.wsj.com/article/SB10001424052702304450004577277482565674646.html?mod=wsj_share_tweet (about 15 paras in)
Wow, if I'd behaved like described there I'd likely have...
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 13, 2012 at 3:38 pm
SQL uses the first log file, then the second, then goes back and reuses the first, then the second, etc. If both files are full and no VLFs are reusable,...
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 13, 2012 at 2:28 pm
Viewing 15 posts - 19,771 through 19,785 (of 49,552 total)