Sounds like the guy we had applying for a senior SQL Server DBA position. When we tested him, he couldn't write a select statement that returned the name and surname...

It really depends on a number of factors. Usually when my developers ask which of a couple of ways will be faster, I tell them to try both and see...

Jeff Moden (10/1/2007)

---

Didn't ask what the decimal value of 2⁴ was... ask which bit would be set. Hint, first bit is called "bit 1" or "bit 0" depending on...

Don't blame MS for this one. The 2005 encryption uses industry-standard, well proven encryption routines...

Are you trying from object explorer? That always tries to create a new connection for every action. You'll have to fix the problem in script.

Don't bother with object explorer....

It wasn't...

If both columns involved in the OR are indexed (separate indexes), there's still a chance of a seek. Not a guarantee.

On the login dialog of management studio, there's options button. Click that and you'll get a second tab that includes a database dropdown. Type master in there and you should...

Do you have to do select *? Selecting all the fields essentially makes creating covering indexes impossible.

Try rebuilding both the NC and the clustered indexes and see if that makes...

Lester Policarpio (10/1/2007)[hr

What if I just want to delete orphaned users in sysusers and i enabled the "allow updates" then disabled it after deleting the orphaned user?Am I doing a...

Don't recall. It took me quite some time to figure out the cause.

Was something like 'Cannot find object NULL'. Seems that SQL does a string concatenation of the owner (null)...

I have the 4 system DB's IDs memorised. It's quicker when reading through syslockinfo. Come to think of it, I have half of my user DB's ids memorised too... :hehe:

I...

Amanda Walshaw (9/29/2007)

---

dear forum,

So dettached the mydatabse from enterprise manger (no one is on the system by the way its a sunday here) deleted the log file and in...

Jeff Moden (9/29/2007)

---

I can't tell you the number of folks I've interviewed who have Masters or PHDs in mathematics that couldn't tell me what bit will be set by 2⁴...

The only time I've ever had to directly modify the system tables was to fix stuff-ups caused by idio^H^H^H^H other DBAs directly modifying the system tables.

Ever seen a table with...