Viewing 15 posts - 26,116 through 26,130 (of 49,552 total)
Is there a question here?
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
May 16, 2011 at 5:55 am
naresh.talla (5/16/2011)
It is because full backup occur..
Nope. Backups don't grow the DB. They write a couple history rows to MSDB, but that's all.
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
May 16, 2011 at 5:53 am
If there's a pre-install rule that says no, then I would highly doubt 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
May 16, 2011 at 5:52 am
Query?
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
May 16, 2011 at 5:09 am
Minaz Amin (5/16/2011)
One thing I want to know : Is MS doing some thing for session continuation as that is taken care in Oracle RAC.
No idea, what does RAC...
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
May 16, 2011 at 5:08 am
Queries, table and index definitions 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
May 16, 2011 at 5:06 am
Files don't grow for no reason. Put some logging in place to record the file sizes, that'll narrow down the time range for you to profile/trace.
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
May 16, 2011 at 5:04 am
Installing SQL on a domain controller is a seriously bad practice. It's strongly not recommended, for security reasons among others.
Am I correct in that the two nodes are DCs of...
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
May 16, 2011 at 5:03 am
azhar.iqbal499 (5/16/2011)
1. Shrink Log File to 1MB
Ow, that's a nasty thing to have done. Now every logged operation is likely to cause the log to grow, you'll get excessive VLFs,...
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
May 16, 2011 at 2:49 am
Rebuilding indexes, no you can wait for the regular maintenance jobs.
What do you mean by 'joins'?
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
May 16, 2011 at 2:01 am
I would add another table, DepartmentID, Year, OverheadRate.
As for the query, no looping required. Just join the tables and filter on the year, simple as 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
May 16, 2011 at 12:03 am
Ninja's_RGR'us (5/15/2011)
copy / paste, setup daily runs and you're done.
+10
No sense in re-inventing the wheel when someone's already done so and ironed out the bugs for you.
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
May 16, 2011 at 12:02 am
Those are all different indexes because the column order is different.
See http://www.sqlservercentral.com/articles/Indexing/68439/ and http://www.sqlservercentral.com/articles/Indexing/68636/
That said, you should never automatically add indexes that missing indexes suggests. Test each one (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
May 15, 2011 at 11:41 pm
Digs (5/15/2011)
[ , [ @new_cmptlevel = ] version ]
--to change to level 80
dbo.sp_dbcmptlevel @dbname=N'test', @new_cmptlevel=80
--to change to level 90
dbo.sp_dbcmptlevel @dbname=N'test', @new_cmptlevel=90...
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
May 15, 2011 at 11:36 pm
Err... no one called you a goat. Did you read the link I posted?
Willie Howard Mays, Jr. (born May 6, 1931) is an American professional baseball player who played 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
May 15, 2011 at 4:09 pm
Viewing 15 posts - 26,116 through 26,130 (of 49,552 total)