778 reputation
39
bio website drewstechnotes.blogspot.com
location Canada
age 35
visits member for 3 years, 7 months
seen May 14 at 19:05

Big SQL fish in a small SQL pond.


Jan
19
awarded  Critic
Jan
19
comment What is the best query to use to monitor a SQL Server database's status?
I don't think the asker was looking for specific recovery information, but rather a query for a general health check. sys.databases is the better spot to find the db status assuming you're running with sufficient privileges to see offline databases. If it's not in sys.databases it's dropped or detached.
Jan
19
answered What is the best query to use to monitor a SQL Server database's status?
Jan
19
comment How should deletions be handled in the database?
I like the boolean and date field. Depending on how you implement the deletion logic you could even have a distinct table which holds the date and the unique key for the record that was "deleted". Stored procedures make this easy. It takes the additional space per row required down to 1 bit vs. 8+. You would also be able to report on deletions per day without touching the source table.
Jan
19
comment Where should one put indexes in a time dimension table?
Does anyone other than me hear Paul Randal's voice every time they say or read "it depends" with regards to databases? :p
Jan
19
awarded  Scholar
Jan
19
comment How do you document your databases?
Also a +1 for extended properties. I use them for all sorts of management related tasks :D
Jan
19
accepted Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?
Jan
19
comment Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?
Interesting... I hadn't even considered sp_spaceused!! Thanks for this Marian, I think that's just what I was looking for.
Jan
19
comment Replicating a remote MySQL database to MS SQL Server 2008
I wasn't aware this was something that you could do with GoldenDate. I'll have to read more about this; thanks for sharing!
Jan
19
comment Replicating a remote MySQL database to MS SQL Server 2008
Remeber that truncating and pulling all the data over each time could be very slow depending on how much data is involved, network latency, etc. It's definitely not the way to go if you have small or slow network links between the two databases. I always try to devise a method that will allow me to pull deltas.
Jan
19
answered Replicating a remote MySQL database to MS SQL Server 2008
Jan
18
awarded  Supporter
Jan
18
answered SQL Server 2008 - Cross database performance on same physical machine and server instance
Jan
18
awarded  Student
Jan
18
awarded  Teacher
Jan
18
asked Is there a reliable way to determine when you should run DBCC CLEANTABLE to reclaim space?
Jan
18
answered How to change SQL Server collation
Jan
18
answered What security threats does the SA account and other known account names pose to security?
Jan
18
awarded  Autobiographer