Grant Fritchey (4/27/2012)

---

I'm not so sure I'd use a trigger. Those things are notorious performance and maintenance headaches.

What about using the OUTPUT clause. You can output the IDs generated from...

Thanks. From those numbers it looks like you need to set max memory for the buffer pool. You have it at 2097152GB, which in peak usage times will allow SQL...

Gopal Singh (4/26/2012)

---

Hello,

I have one parent & child table and i have make relation ship using a foreign key. Primary key in parent table is forein key in child table.

So...

It's kind of tough to visualize with no DDL, sample data and desired results to infer your requirement and test code against...can you provide that?

Some guesses though...initial thought was two...

Security is a big topic in SQL Server...but for a simple approach abide by the notion that "a database user should only be able to do what is needed to...

My first thought was to check the Login facet @sid property to see if it was NULL, but that turned out to be harder than it should have been. Then...

Allow user defined functions to be called in the same manner as Builtin functions

Just looking out in case you were now supporting a database that originated on 2000 and had some impure data. I inherited a bunch of 2000 DBs a while back...

It's a good idea to make sure Data Purity was run cleanly since the upgrade. The info is on the same page Gail pointed you to 😉

CHECKDB From Every Angle:...

Note that just restoring the database will not make it fully operational on the 2008R2 instance. You also need to make sure you transfer the Server Logins used within that...

Test_plan-1.sqlplan

It looks like you could benefit from an index on Users.ID that INCLUDEs email but I need to see the DDL to be sure. Can you please provide the DDL...

What does the proc do? It, or something else in the stack, may be changing your security context using EXECUTE AS or sp_unsetapprole. Can you post the procedure code?

DBCS is not natively supported in SQL Server, only ANSI (CHAR & VARCHAR) as well as Unicode (NCHAR & NVARCHAR). If you want to store DBCS in SQL Server it...

Still no answers on desired Collation of returned VARCHAR types...no answer to answer potential substitution issues if no E/ASCII code point is found...no answer on how exactly to strip apart...

+1 for Service Broker (SB)...the use-case described might be the most common of all. And no, no concerns about reliability, Microsoft uses SB within the SQL Server Database Mail subsystem,...