Reputation
704
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 19
Newest
 Yearling
Impact
~11k people reached

Dec
26
comment How to restore a database from the SQL 2008R2 log?
It's times like these that I finally understand why some DBMS are not auto-commit.
Dec
10
comment Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?
We're all going to scream that your DBA is a moron if that's all they said, but are you sure there wasn't other context to your DBA's argument?
Nov
27
comment Migration of MySQL to SQL Server
How is this programming related?
Nov
25
comment SQL Server's BACKUP DATABASE - how to access the original exception?
@YuriMakassiouk Backups deal with DBA responsibilities. I think it's a decent fit.
Nov
25
comment SQL Server's BACKUP DATABASE - how to access the original exception?
This question belongs on Database Administrators
Nov
21
comment Does restoring database clear buffer cache and stored proc cache
Have an upvote for being late to the party.
Nov
21
comment Does restoring database clear buffer cache and stored proc cache
Your screenshots aren't pretty, but here's an upvote.
Nov
21
comment Does restoring database clear buffer cache and stored proc cache
+1 learned something today
Nov
21
comment Does restoring database clear buffer cache and stored proc cache
If you're restoring from a backup, then I don't believe it does. I could be wrong and will happily hear why.
Nov
20
comment SQL Server log file continues to grow?
While link answers are helpful, it's beneficial to point the OP to the specific part of the link, or even include it in your answer.
Nov
20
comment SQL Server log file continues to grow?
This question belongs on Database Administrators
Nov
5
comment Make “as” mandatory when create column alias?
Not possible. The only way to enforce this is by nagging the people who write the code.
Nov
5
comment How do you see which database on a Server uses most resources
You should blog about this.
Nov
5
comment Why are we suddenly getting time-outs on multiple transactions?
Space available: 1.93MB ... Add more floppy's.
Nov
4
comment Understanding Indexes and using them better
If I could only get rep for it.
Nov
4
comment Understanding Indexes and using them better
Use them to the MAX()!
Nov
1
accepted create linked server to vertica
Oct
31
revised create linked server to vertica
deleted 18 characters in body
Oct
31
comment Table Design Cardinality
I'm probably not fully taking into account your entire schema, however, there is nothing wrong with having flag columns that identify a user as a vendor or buyer.
Oct
31
answered Table Design Cardinality