Viewing 15 posts - 15,721 through 15,735 (of 22,211 total)
CirquedeSQLeil (3/12/2010)
Grant Fritchey (3/12/2010)
I'm holding out for the Adequate DBA Competition. I'll be GREAT!
Why not the Barely Meets Expectations DBA?
Could you imagine the competition? :hehe:
And yes, it's Brad's book on...
March 12, 2010 at 12:06 pm
I'm holding out for the Adequate DBA Competition. I'll be GREAT!
And yes, it's Brad's book on how to be an exceptional DBA. It's really worth a read.
March 12, 2010 at 11:55 am
GilaMonster (3/12/2010)
Paul White (3/12/2010)
GilaMonster (3/12/2010)
Gianluca Sartori (3/12/2010)
March 12, 2010 at 11:32 am
That's a classic case of parameter sniffing. SQL Server is able to use the hard coded value to determine that the index has what it needs and is relatively low...
March 12, 2010 at 11:01 am
I'm going to assume the column is a datetime and you're not taking into account the time aspect of the date math.
March 12, 2010 at 10:25 am
Paul White (3/12/2010)
Grant Fritchey (3/12/2010)
And when you make the query into a procedure as Paul says, make the parameters NOT NULL and the users will have to supply them.
Good point...
March 12, 2010 at 9:52 am
Bhuvnesh (3/12/2010)
kvtraju (3/12/2010)
Hi everyone iam newbie can you guys suggest me the best handbook on dba administration 2005Dont forget to read SQL_Server_Execution_Plans by Grant Fritchey, Amazing Book
Thank you, very...
March 12, 2010 at 7:11 am
I think Jason was kidding on that one. But hey, the more posts with my book in them, the better.
😀
March 12, 2010 at 6:42 am
Yes, a SELECT statement places a shared lock on the table, not an exclusive lock.
March 12, 2010 at 6:23 am
And when you make the query into a procedure as Paul says, make the parameters NOT NULL and the users will have to supply them.
March 12, 2010 at 6:21 am
Another vote for Books Online. I have it open on my desktop all day, every day.
But, sometimes, on some topics, BOL can be structured funny, so having access to other...
March 12, 2010 at 6:11 am
You say "restore" but did you run a command BACKUP DATABASE and a command RESTORE DATABASE or did you use some sort of migration routine or the Copy Database wizard?...
March 12, 2010 at 6:06 am
Joy Smith San (3/12/2010)
I've found that when I had to use linked servers, OPENQUERY provided much faster results.
It's amazing..! Open query is too fast...to be precise, it fetches data...
March 12, 2010 at 5:53 am
GSquared (3/11/2010)
CirquedeSQLeil (3/11/2010)
GSquared (3/11/2010)
As promised a couple of months ago, I've updated to having a beard in my pic. 🙂Holy Crap - who is that?
That's me with 2 months...
March 11, 2010 at 12:40 pm
Viewing 15 posts - 15,721 through 15,735 (of 22,211 total)