Yeap your right ..

If you go to http://www.microsoft.com/technet/security/Bulletin/MS09-004.mspx, and scroll down fair bit you'll find "FAQ" section.

Expand that in there it lists the patch to install for SQL...

[font="Courier New"]DECLARE @Value AS VARCHAR(255)

SET @Value = '200702071630+1100'

SELECT CONVERT(DATETIME,LEFT(@Value,8))

[/font]

Do you mean that? Output of that statement is "2007-02-07 00:00:00.000". Thanks.

Another good one is ...

http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/

🙂

Nuts :p. I guess I'll have to butcher a server LOL thanks for the post :). I made a note about this on me blog so I wouldn't...

Question ...

Was error similar to this:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Exception has been thrown by the target of an invocation. (mscorlib)

------------------------------

ADDITIONAL INFORMATION:

An error has occurred while establishing a connection...

Heh I expected as much; I have yet to rename any SQL 2005 servers. I am sure I'll get around to it; I'll have to keep this little note...

I think that strongly depends on how they were encrypted? Keys? Pass phrase? certificates? SQL Server 2005 has nice set of encrypt/decrypt functions. But in all cases (someone...

Hey,

If you remove the filter aka where clause you'll get the full records :). Just the 3 fields from his order tables will show up as null...

That is a very nice article to take advantage of row count information in indexes tables. But I though you needed to know when someone is selecting information? ...

florian.reischl (3/7/2009)

---

Yeah there is no other language more flexible than SQL... I'm doing that since about ten years now and I'm still learning 🙂

For the SQL formatting:

I saw this first...

Yaa probably "c.id *= o.customer_id" causes me alot of heach though when upgrading old SQL 6.5 applications to newer version. I always always trying to talk to my friend...

Heh Thanks :). I got alot to learn about T-SQL .. meh but then I got lot to learn about DBA stuff too 😛 Thus the reason of...

Compression would be an option for you.

I am not sure how well backups compress with standard compression tools; but tools like RedGate Backup work nicely to compress it before shipping...

I am looking froward to the blog entry once you close the poll; the results look scary heh.

HI Yihong,

IMO, they are same however that said I am against the first styles. In that example because it makes it hard to read the SQL Statement....