Keep in mind that sp_change_users_login ONLYworks for SQL Server Logins

The Reason BULK INSERT is faster than bcp is because it runs IN-PROCESS that is why M$ uses "INProcess Loader" term to refer to it and "Out-of-process Loader" to refer...

I have faced this problem before in jdbc. what happens is that your prepared stament was previously compiled with a set of parameters that have a very different distribution of...

it is a recommended practice that when you use subqueries you prefix all column names with a table alias!

Totally agree with Matt and you can use either Min or Max ... just be carefull if you have Nulls !

Mark Shvarts (9/26/2007)

---

I have a script:

with problem(problem_name, kount)

as

(

select

problem_name = pr.name,

kount ...

Those indexes that do not go further down in "fragmentation" levels are ususally part of very small tables so I would not worry about those at all because for small...

I had a similar issue of missing-at-the-publisher records but I am still investigating ....

If you have found anything, can you please let us know

I can't find anyway of determining whether or not a column is computed. In a couple of tables I use computed columns and obviously if I try to insert...

Before you go and run to implement SIMPLE recovery mode make sure that your managers understand the "data loss" risks they are exposed to and only if it is acceptable...

This a very "risky" proposition which I would doubt most people would dive into.

Matt,

I never meant to say that you are running clusters on cheap hardware :D. I just mentioned that the entire system not just the SAN must be certified to work...

Sorry Matt, but I could not disagree with you more in some of your replies 😀

A standard MSCS setup of SQL server requires no specialized hardware (an extra NIC, and...

Clustering Technology on MS SQL Server is IMHO the most hyped least bang-for-the-buck thing people tend to use. The expense you incur with all that specialized hardware is really not...

You should use separated log files so that you can recover the "chain". Some people do like a single TLOG backup file but my personal experience indicate that is easier...