Hi I just ran you script in tempdb on my laptop (3GB RAM Win 2008/SQL 2008 64-bit) the select count(*) and select * both returned within a second....
Hi All, Thanks for all the help. This is what I am going to do in the QA environment to make sure there are no side effects. 1. Do a differential...
Thanks for you reply. So should I set recovery to bulk logged at the start of maintenance plan after the back up, and switch back to full at the...
Hi All, I have a couple of questions about a maintenance plan I putting together for our production servers. Here is some background. We do a full...
Hi You can detect which spid is running which stored procedure. My question would be why would you? Its like force only one user at time to be able...
Hi Use the dedicated admin connection. For trusted connection use SQLCMD -S <servername> -E -A For sa connection use SQLCMD -S <servername> -U sa -P...
Hi This error can range from a lot of connection issues from Vista firewall blocking the tcp port, to SQL server instance not having TCP protocol...
Hi All, As long as the default trace is running you should be able to see when the object (table) was dropped (event class id 47) and by which...
Hi have you checked the default trace log? By default it is on, and is stored in log folder under the instance. You use this statement to get the...
Hi, Remember that IN cause will put in an OR statement inbetween all 791 results, so if the OR fails after 497 rows then the query will take longer....
Hi If t1.Date_Taken is VARCHAR(10) and you are using style 101 (mm/dd/yyyy) your query will be return not only the last 7 months data, but the...
Hi Ganesh, Are you retrieving the count everytime the page is return or once at the start? I normally have two stored procedures for this, the first...
Have a look at http://sqlserveruniverse.com/content/PERF0600104282008MeasuringPerformanceOfStoredProcedures.aspx it may be of help. Also SQL Server...
Hi Depending on how you are going to be using this info have you tried the system stored procedure sp_spaceused '<table name>'. It uses information...
Hi Saigeeta, My first question would be why does it take 10 minutes to transfer 100 records locally. What is the DTS package doing, is it doing a...
Hi You can use the 3 part object naming syntax for this. <datbase>.<schema>.<object> Example UPDATE Database1.dbo.Table SET off = 1 WHERE username =...
Hi I take it you have either switched off the autogrowth for both data and log, or missed this feature when creating the database. Anyway at any...
Hi If this is SQL2005 then look at database triggers. Richard...CREATE TRIGGER disabledropON DATABASE FOR DROP_PROCEDUREAS BEGIN RAISERROR ('You...
Hi I hate to disagree with you, but you have a trigger called tU_BL or at least another object/procedure that is linked to BL table. Type in the...
Hi Here is an example on how to do it. Its not the most efficient and I am sure that someone else will give a better example. Basically it uses...
Separate names with a comma.
