One neat little easter-egg about CTEs that I'll throw out there is that they can be executed multiples times if they are referenced multiple times by your query. It is...

I wrote a proc several years...

Unfortunately I do not think you can unless you execute the command from something like PowerShell or C# where there is an Exception Collection available. In T-SQL you will only...

Henrico Bekker (4/20/2012)

---

3. Are you running 32bit with more than 4GB Physical Memory?

If yes, then AWE can with additional setting to the OS make use of more memory.

If NO, AWE...

You could go down the road of using a scheduled job to act as your "PowerShell runner", just know that sp_start_job is going to start the job and return control...

spin (4/20/2012)

---

what i now have instead of

if A

@var = select .......

if B

@var = select .......

if C

@var = select .......

i've instead created 3 stored procs so

if A

exec proc1 val1, val2, val3

if...

AIRWALKER-375999 (4/20/2012)

---

Thanks for your response. I have already tried that appraoch but because the files are created at the same time the 2nd watcher does not recognise the 2nd...

How did you migrate the database? If you did a backup/restore or detach/attach did you update usage stats and rebuild all your indexes after the migration?

On SQL 2005, no, not unless you have trace flag 1222 or 1204 enabled or had a server-side trace running.

If you're worried about deadlocks enable 1222 (only) globally and future...

qgudex (4/19/2012)

---

Thanks for the responses guys.

I originally tried adding the account to just dbcreator, but it seems that this does not actually make the account "owner" in this case. ...

For the record BULK INSERT and bcp will not import Excel files (xls or xlsx files in binary format). Those tools are meant for importing plain-text files.

Happy to assist, you're in the right place to pickup a few good nudges here and there 😉

.

spin (4/19/2012)

---

hi

sorry i just abbreviated the joins for simplicity.

the problem with the way your suggesting is that the select statement has many more columns and some other joined table...

toddasd (4/19/2012)

---

opc.three, couldn't the where be combined like so (not checked for syntax):

select a.year, a.month, a.product, b.sales, b.units

from all_dates_and_products a

left join my_sales b on

a.year = b.year

and

a.month = b.month

and

a.product =...