Viewing 15 posts - 6,916 through 6,930 (of 9,707 total)
During the upgrade process, SQL Server 2k5 automatically creates a schema for every user. It's a "feature" that Microsoft put in for who knows what reason. Schemas are new to...
December 3, 2010 at 4:28 am
Henrico Bekker (12/3/2010)
Hi guys, could we get some comments on the today's QOTD please?Need some more senior input.
Yeah, but honestly, Microsoft could be more clear in their KB article too.
December 3, 2010 at 4:24 am
T-SQL is required to create the snapshot, but how many people create snapshots using jobs or SSIS packages? Most people open up SSMS to do it, ergo, the common perception...
December 3, 2010 at 4:22 am
Craig Farrell (12/2/2010)
How often do you re-write old code, except for a few specific core procs on any system?
Often enough that I save all my procs so I can re-use...
December 2, 2010 at 11:53 am
CirquedeSQLeil (12/1/2010)
Brandie Tarvin (12/1/2010)
Certifiable.Yeah. Couldn't resist that one. @=)
Yes I am - woohoo :hehe::satisfied::alien:
The proper response is "I know you are, but what am I?" :w00t:
December 2, 2010 at 10:48 am
artan_p (12/2/2010)
Hi!In my project I have used Qureis, maybe I must use procedures
Could it be my problem!?
We're not going to even try to answer that question until you tell us...
December 2, 2010 at 8:51 am
Can anyone point me to a good example of an abstract that was submitted for PASS? A weblink or something?
I want to apply as a speaker for SQL Rally and...
December 2, 2010 at 7:32 am
It sounds like either a network issue or a permissions issue. If you're not willing to look at Craig's questions and test them out for yourself to verify none of...
December 2, 2010 at 5:58 am
Certifiable.
Yeah. Couldn't resist that one. @=)
December 1, 2010 at 12:44 pm
JRUDE (12/1/2010)
My apologies. I had not read through all of the responses prior to posting my reply. Your explanation was very clear. Thank you for being kind.
No...
December 1, 2010 at 12:33 pm
Stefan Krzywicki (12/1/2010)
The LIKE '%[0-9]%' will return any string that has any number in it anywhere.
The NOT LIKE '%[^0-9]%' will return any string that has only numbers in it.
This is...
December 1, 2010 at 12:32 pm
JRUDE (12/1/2010)
Perhaps I'm missing something, but doesn't the following do the same thing in a more straightforward way (without the double negatives)?somecolumn like '%[0-9]%'
Go back and re-read the last two...
December 1, 2010 at 12:25 pm
We are feasting today upon Lemon Sponge Cake with Lemon frosting (as in lemon flavored frosting).
Scrumptious.
December 1, 2010 at 11:04 am
Maybe I'm off base here, but could the scan be caused by SQL Server pulling the data and then checking the permissions for each record to see if the user...
December 1, 2010 at 11:01 am
Viewing 15 posts - 6,916 through 6,930 (of 9,707 total)