you'll want to dbcc reindex the database now. basically the space that was used by the char fields is still there, and new space was added for the varchars....the system...

You could test how many fields are empty, ie  null/not null, but not how of often they are used.

when SQL inserts or updates a row, no statistics are available wether...

Correct me if I'm wrong, but the blocker script is an example of what happens when you have high volume inserts, right?  I've read that the identity() column can have...

by slow you mean it takes a long time for EM to display the list of databases?

If that is true, then it's a known issue where if each database needs...

here's teh puedocode that I currently use for something similar:

add one more column to your tracking table, a flag or field to signify "NotificationSent' or something.

now create a job that...

there is no change for the users; remember that their logins and permissions are mapped to roles in each of databases on the machine. Esentially their permissions are stored in the...

without more information, I don't believe you can.

is there an identity column in the tabe? is there a datetime field for creation or updated?

if the primary key might be (Accountno,AdmissionReason), then...

i looked at sp_addalias, and it looks like any users that are aliased as dbo would have the sid for sa/dbo (which is always 1):

    -- INSERT SYSUSERS ROW --

   ...

there's a difference between changing a machine name, and changing a named instance.

for example, if my machine is named DEVPLATFORM, and I want to rename it as DEVELOPER, I right...

since all three of these tables (sr_srvc_request_v,sr_note_v,sr_activity_v) are joining on the srvc_request_num column, all three might also benefit from an index on their srvc_request_num column;

I'd look at the execution plan...

it looks like your batch number is arbityary...can it be based on the workID?

select 'us' + RIGHT('000' + (convert(varchar,(workID / 100) + 1)),3)

select 'us' + RIGHT('000' + (convert(varchar,(1 / 100)...

good catch and sorry for the typo;

check to see if there is an index on ra_review_t.srvc_request_num ;

all three joins use that for this query, and it might speed up if one...

as a developer will this allow them to see the text?

SELECT TEXT FROM SYSCOMMENTS WHERE ID=object_id('USP_IE_GET_INVOICES_BY_USER_ID')

if that does work, you could create your own proc and grant them...

something like this might help you; note i limited it to top 100 because this can be a huge result set on some db's: the columns in the sqlstatmenet are...

if (SELECT     COUNT(*)

FROM        inserted INNER JOIN

                      tblInternalEduModule ON [inserted].[Quiz Name] = tblInternalEduModule.Quiz

WHERE     (tblInternalEduModule.Category = 'WIN') ) !=@@rowcount

that looks invalid to me. select count(*) from inserted will set @@rowcount...