Hi

If speed is the issue, then use the right tools, right?

Research VDI. In my experience writing from VDI device connected to a seperate server hosting the backup file was...

Hi guys and girls

I'd like to know why no-ones considered the Delete Cursor...

DELETE

[ FROM ]

{ table_name WITH ( < table_hint_limited > [ ...n ] )

| view_name

|...

Thanks, guys, for affirming my understanding:

Query for reports: PROCS

While migrating the environment from Free-For-All to Reports-Only - I need to go through the locking down phase first. At the lowest...

So, what is the "best practice"?

Stored Procedures accessing base tables, views.

Database Roles granting execute / select / update permissions to objects depending on Role

Logins assigned Roles depending on business requirement?...

Hi guys - great work determining missing rows.

I was wondering what the best way to go from the list of missing rows, to a list containing ranges of missing rows,...

Further to my previous post, I attach the error message generated when MODIFYING the plan created by my colleague. I assume it's a SQL Management Studio error more than anything...

Hi. With great interest I note your approach, and the approach using id = id-1.

I have this but more: we get data for (11) different types, each type has it's...

Hi

I did something similar like this:

while charindex('|',@FundCodes) <>...

Um, try space after -S in -S' +@@ ie:

select @sql = 'bcp "select * from ORLANDO..vwEmpReport" queryout

c:\bcp\report.csv -c -t, -T -S'+ @@servername

CHANGES TO:

select @sql = 'bcp "select * from ORLANDO..vwEmpReport"...

Dear Teaque

I am developing a multiple report generating DTS which dynamically creates spreadsheets in an Excel file.

When I run the DTS components in sequence, manually, it works. When I...