Viewing 15 posts - 48,421 through 48,435 (of 49,571 total)
Wapper (10/3/2007)
GilaMonster, I cannot use convering index because next_id and status are only used for finding records, but to display what I've found I need all fields.
You might still be...
October 3, 2007 at 6:17 am
First, a big, big thank you to Lara Rubbelke from Microsoft who presented on this at PASS recently. This code is derived from her presentation, and not somethng I came...
October 3, 2007 at 5:49 am
Ok, now that the crises are out of the way and I have a couple free minutes, let em see what I can conjure up for you.
This is going to...
October 3, 2007 at 4:43 am
I joined SQL Central about 5 years ago, intitially as a place to get answers to problems I had with SQL. At the time I was just starting out on...
October 3, 2007 at 4:31 am
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...
October 2, 2007 at 7:00 am
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...
October 2, 2007 at 12:48 am
Jeff Moden (10/1/2007)
Didn't ask what the decimal value of 24 was... ask which bit would be set. Hint, first bit is called "bit 1" or "bit 0" depending on...
October 2, 2007 at 12:24 am
Jeff Moden (10/1/2007)
Didn't know that. Wow... the boy's in Redmond pretty much blew it there...
Don't blame MS for this one. The 2005 encryption uses industry-standard, well proven encryption routines...
October 2, 2007 at 12:16 am
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....
October 1, 2007 at 10:39 am
Robert Heynen (10/1/2007)
Gal...can you direct me to the PASS article you speak of, and yes, it would be fabulous to have some semblance of code I could reference to...
It wasn't...
October 1, 2007 at 10:14 am
If both columns involved in the OR are indexed (separate indexes), there's still a chance of a seek. Not a guarantee.
October 1, 2007 at 9:59 am
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...
October 1, 2007 at 9:57 am
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...
October 1, 2007 at 6:12 am
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...
October 1, 2007 at 3:28 am
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)...
September 30, 2007 at 2:10 pm
Viewing 15 posts - 48,421 through 48,435 (of 49,571 total)