Why SQL Server 2005 Doesn't Permit Non-ANSI Style OUTER JOINs
As of SQL Server 2005, any database in 90 compatibility mode (settable by sp_dbcmptlevel) cannot support non-ANSI OUTER JOINs. Sometimes...
2007-11-01
2,184 reads
SQLSaturday Finally Has a Logo
Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...
2007-10-31
1,442 reads
Nominations INETA North America Board of Directors
Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...
2007-10-31
1,415 reads
Tool: KeePass Password Safe password manager/vault
Some time ago I was looking for a password vault and came across some recommendations for KeePass. KeePass is open...
2007-10-31
2,607 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-30
1,966 reads
SQL Server: Listing all the database roles for a given database user
SQL Server 2005 introduces Common Table Expressions (CTEs), which are great for recursive queries. Previously, in order to do recursion,...
2007-10-30
2,569 reads
How Much Pizza and Soda for a User Group Meeting (Why You Should RSVP)?
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,450 reads
Becoming a DBA, Part I
A recent thread on SQLServerCentral.com had an individual what it took to be a successful DBA. Couple that with a...
2007-10-29
1,676 reads
Structuring the Blog Better
For a variety reasons, including personal/family concerns and workload, I've not been able to write as often as I'd like....
2007-10-28
1,466 reads
Views for Abstraction Posted on SSC
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,363 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers