Viewing 15 posts - 24,736 through 24,750 (of 49,552 total)
cfradenburg (7/22/2011)
I could have sworn that there was a function you could run to see if any enterprise features are being used but I can't track it down.
sys.dm_db_persisted_sku_features
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 22, 2011 at 3:34 pm
As long as the DB doesn't use any persisted enterprise-only features (partitioning, compression) and is below the Express size limit, you can backup/restore.
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 22, 2011 at 9:42 am
Replication or manual are your only options. Mirroring won't work down-version.
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 22, 2011 at 8:57 am
crazy4sql (7/22/2011)
PS:- System database with resource are on same disk which need to replaced. Disk is not getting expanded but being replaced with new more storage disk.
In 2008 the resource...
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 22, 2011 at 8:53 am
crazy4sql (7/22/2011)
Thanks Gail, so what the best approach you suggest?
Move the user and system databases where ever you like.
Unless you're planning to move things like sqlservr.exe and it's related executable...
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 22, 2011 at 8:22 am
Don't. Move it and SQL will break. In 2008 it has to be treated like any of the program dlls.
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 22, 2011 at 8:08 am
Dom Horton (7/22/2011)
Basically at this stage I wish to know if, on the face of it, is my SQL logic sound? Are the two SQL versions logically equivalent?
In this...
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 22, 2011 at 4:58 am
Jayanth_Kurup (7/22/2011)
maybe you cud try something...
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 22, 2011 at 4:53 am
No. You can log deadlocks with an alert because a deadlock is an error message and alerts fire for errors. There's no error fired when a stored proc executes.
You could...
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 22, 2011 at 4:48 am
Go read the docs then. There's lots of good cluster-related documentation (I know, I had to go searching when I first started working with clusters)
I don't have a cluster handy...
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 22, 2011 at 4:42 am
colin.Leversuch-Roberts (7/22/2011)
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 22, 2011 at 4:31 am
Afraid not, I'm not all that familiar with clustering other than the theory, and how to do it depends on the version of windows.
Ask the networking people. If they set...
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 22, 2011 at 4:22 am
The drives must be cluster resources and set as dependencies of the SQL group.
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 22, 2011 at 3:57 am
Eric M Russell (7/21/2011)
When in doubt, then use LEFT JOIN.. WHERE.. IS NULL, because it will scale better for very large rowsets.
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
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 21, 2011 at 7:52 pm
None of those will help with 448. 448 is a BI exam, you'll need books that cover SSIS, SSAS and SSRS.
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 21, 2011 at 7:46 pm
Viewing 15 posts - 24,736 through 24,750 (of 49,552 total)