What command did you use to defrag your indexes?  Have you considered rebuilding them?

John

Bagath

There's an undocumented extended stored procedure called xp_eventlog.  I don't know exactly what it does or even whether it would be right for what you want, but I'm sure you'll...

Kumaran

The only way I know is like this:

(1) Script out your logins, jobs and so on

(2) Back up your user databases

(3) Uninstall SQL Server

(4) Install SQL Server RTM

(5) Apply SP3a

(6)...

Yes - my free download also included SQL Refactor and SQL Doc but only had a licence key for SQL Prompt.  When I contacted Red Gate they apologised for any...

Dave

The same principle applies - schedule a regular job that scripts out the users and groups regularly.  I don't know exactly how you'd do that, but the NET USER and...

Ninel

You need to trap error message 1205.  See Detecting and Ending Deadlocks in Books Online for more details.

John

Joe

So the Code column in your nuts_Names table has NULLs in it?  How do you want to deal with those?  It would help if you could provide the CREATE TABLE...

Dave

It depends on how you are doing your DR.  If you are restoring all databases, including master, at the DR site, then you don't need to do anything to recreate...

James

I take your original question as meaning that you're looking for the existence of the stored procedure, rather than its use.  If that's the case you don't need a Profiler...

Open the Client Network Utility, click on the Alias tab and click on Add.  Choose the TCP/IP radio button.  Type the SERVERNAME\INSTANCE in the Server alias box, the IP address...

If you're doing this as part of a SQL Server Agent job, you can choose Operating System Command from the drop-down list in the job step box.  But as for...

Susan

Beware if you have any negative numbers in that column.  For example, -1.5 will be converted to -2.  If that isn't what you want, you need to put a bit...

UPDATE basic

SET alternate_id = FLOOR(CAST(alternate_id AS DECIMAL))

Susan

If all the data in your column is decimals, you can convert to a number and take the integer part:

SELECT FLOOR(CAST('2345.123' AS DECIMAL))

John

Charlie

Try putting that query through the Database Tuning Advisor and see what it suggests.

Generally speaking, you will want indexes on columns used in JOIN clauses, WHERE clauses and ORDER BY...