Viewing 15 posts - 20,986 through 21,000 (of 49,552 total)
Anamika (1/16/2012)
I have a fact table which is getting loaded with 1 GB of data every day.
Instead of running the ETL once in a day, there is a proposal 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
January 17, 2012 at 2:16 am
Wiki's not the only site. Reddit's going dark tomorrow, so's Mozilla.
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
January 17, 2012 at 1:59 am
Those are usually fine as defaults (and I believe it's what both of those scripts use by default).
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
January 16, 2012 at 3:15 pm
Another option, especially if there's a middle-tier for the application, is for the app to impersonate a different windows login for connections to the DB. That way, the users don't...
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
January 16, 2012 at 3:14 pm
You also need to watch out for maintenance plans which, iirc, get an application name of SQL Server Management Studio.
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
January 16, 2012 at 2:43 pm
No, not really. bulk logged recovery won't reduce the size of your log backups. You've pretty much got the choice of rebuild selective (which I do on anything other than...
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
January 16, 2012 at 2:38 pm
Don't use maintenance plans for index maintenance. It rebuilds everything regardless of whether the indexes need rebuilding or not. Use something like the scripts from http://www.sqlfool.com or http://ola.hallengren.com/Versions.html
If need 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
January 16, 2012 at 1:58 pm
They wouldn't be useful for backing up the SSIS packages, they're in MSDB or the file system.
Backups of master are essential for logins, server-level permissions, linked servers, user databases, etc.
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
January 16, 2012 at 11:36 am
That's a little bit of a vague question, can you clarify a little please?
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
January 16, 2012 at 11:35 am
thang_ngo_2002 (1/16/2012)
SQLKnowItAll (1/16/2012)
is my solution correct ("db_denydatareader" to MASTER)
No, it is not correct.
Could you please explain me why, I'm try that way, I can connect from my program and...
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
January 16, 2012 at 10:49 am
thang_ngo_2002 (1/16/2012)
but is my solution correct ("db_denydatareader" to MASTER), it's very easy and simple ?
What exactly is that intended to achieve and why do you think it will work?
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
January 16, 2012 at 10:44 am
SQLRNNR (1/16/2012)
GilaMonster (1/16/2012)
Revenant (1/15/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
January 16, 2012 at 10:28 am
I've seen this twice before and heard about it another time. In all cases a restart was required. Check that the rollback isn't blocked by anything first.
As for the 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
January 16, 2012 at 6:41 am
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/
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
January 16, 2012 at 6:16 am
http://msdn.microsoft.com/en-us/library/bb677185.aspx
http://msdn.microsoft.com/en-us/library/bb630351.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
January 16, 2012 at 5:35 am
Viewing 15 posts - 20,986 through 21,000 (of 49,552 total)