Viewing 15 posts - 31 through 45 (of 61 total)
ta.bu.shi.da.yu (6/17/2009)
I'm curious where it speaks about rounding in the linked article... I couldn't see it anywhere. It just says the default for the precision and the scale!
True, you would...
June 17, 2009 at 9:05 am
June 12, 2009 at 7:51 am
From the referenced Microsoft whitepaper...
System databases other than tempdb cannot currently be encrypted by using TDE.
I wonder if there are plans to expand TDE usage to these system databases? For...
June 10, 2009 at 6:58 am
Good job mentioning the offsite tape testing. It's a good idea to get at least an annual test in the budget and make sure that the time to recovery doesn't...
June 8, 2009 at 7:41 am
Here's to "wrong" correct answers, a seemingly simple question led to quite an interesting discussion!
BTW, I wonder how many of us created char(1) and varchar(1) variables and executed DATALENGTH on...
June 5, 2009 at 4:39 pm
Respectfully disagree with the answer; I'd actually say varchar(1) is the worst choice. You've got the +2 byte overhead for allowing variable length when the question states the length will...
June 5, 2009 at 5:44 am
Chris Harshman (6/1/2009)
With everyone getting into their religious entrenched positions ...
So far it isn't too religious, nobody has brought up parameter sniffing yet.
June 1, 2009 at 9:28 am
Gail's article a few month's back on catch-all queries covered this territory really well:
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries
Sunil's method is acceptable on small tables, but on larger tables this will choke a...
June 1, 2009 at 5:42 am
blandry (5/29/2009)
- Immediately start using steroids?
- Open up a pit bull fighting arena in my backyard?
-...
May 29, 2009 at 9:42 am
Good question, it seemed to me that the main point was learning that you could execute a SSIS package from BIDS, the other choices are probably well known by anyone...
May 29, 2009 at 6:39 am
To me, salary is not everything in our line of work, so making that piece of information public would not provide much benefit. I value what I get to work...
May 29, 2009 at 6:31 am
GRE (5/27/2009)
Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will that remain?
Yes,...
May 27, 2009 at 6:29 am
Is the answer going to be fixed, it should be Standard and Enterprise according to Books Online (see Change History at bottom of page referred to in above comments)? Also...
May 26, 2009 at 10:45 am
ppcx (5/21/2009)
3 gives:Msg 207, Level 16, State 1, Line 2
Invalid column name 'EmployeeId'.
Is your database collation case sensitive? That would be the reason "EmployeeId" is invalid, because it's actually "EmployeeID"...
May 21, 2009 at 9:31 am
Viewing 15 posts - 31 through 45 (of 61 total)