Recent content by DrSql

You need to right click on the db got Tasks Import/Export. Dr.Sql Good Luck.

Can you please post the error and also confirm the access to folder that you are backing up. It’s always recommended to use windows authentication service accounts. Dr.Sql Good Luck.

You approach is right but I would suggest to pre-allocate the required space to primary group and this should help your merge quicker. Also verify that the second file groups are in primary group or diff files? If it’s different file groups then you need to move the object to the primary...

It’s all depends on how critical your data is and how much Swiss cheese holes let your security team allows in your firewall. The safe bet is your third option and SQL Server has a new version to accommodate that is SQL Server Web edition. Web tier directly connects to SQL Server web edition and...

As DBA we have been debating with our developers whether we should be using CLR Stored procedures or SQL Server Stored procedures. Is there any have any experience with it or suggest the Pros and Cons. Thanks in advance. Dr.Sql Good Luck.

SQLBill's recommendations are the right approach. I would also suggest running the profiler, filter duration > 10 Sec to start with and take the query that taking the longest start running through Index tuning advisor. Also profiler would let you capture trace for a period and you run it...

Few more questions :) You verified the fragmentation for all tables used in the query? How much data you are querying as output? Does it have lot of joins? Can you check the buffer cache and disk io? Is your prod and dev using same type of disk in tiers? I would still explore running a...

Here is a simple tool http://www.brothersoft.com/sql-server-version-checker-download-32177.html Dr.Sql Good Luck.

I meant there are sveral way you can decide your re-index jobs and its available on-line. What we have decided to deploy in an environment that has more than 200 instances is that Re-Index Sun 1.00 AM Update Stats: Thur 1.00 AM Re-Index Configuration variables: -- Less than 30% Fragmenation...

The rule of thump for pagefile is 1.5 of the total memory and reccomned to leave 512 on C:\ for OS and reamining can be distrubuted on other drives. That ebing said I would suggest compare the the db and table fragmentation you can use DBCC SHOWCONTIG and look for SCAN DENSITY. Here is a good...

Re-index and Rebuild is recommended based on fragmentation level and there are several scripts but I won’t suggest running shrink as part of it. If the db and log file grown to a size during the maintenance jobs then leave the size intact, constant file growth and shrink can cause disk...

Is this first occurnace? Then you should explore if anyone else running any long running queries that uses tempdb also suggest to look into maintenance? Any recent schema changes? Is there any un-expected grwoth to DB? Monitor for next week for same window also if needed run some trace. Good...

As John stated a lot depends on your email communication relay and its pretty relaible. I have custom alerts configured for business crtical app to send direct emails rather than using our monitoring tool and it has been more relaible than exteranl tools. Good luck Dr.Sql Good Luck.

Amazon.com might be the best bet. Dr.Sql Good Luck.

Yes, there is an "in place" upgrade but I would suggest only if you were upgrading DB Engine, else I would suggest a complete re-install. In 2008 there is no longer required IIS for SSRS and SSIS needs to re-deployed to 2008, and I haven’t worked on SSAS but assume you might have to make some...