meta user
network profile
| bio | website | drewstechnotes.blogspot.com |
|---|---|---|
| location | Canada | |
| age | 34 | |
| visits | member for | 2 years, 4 months |
| seen | Jun 29 '11 at 16:19 | |
| stats | profile views | 31 |
Big SQL fish in a small SQL pond.
|
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 |
|
Jan 18 |
answered | Where can I find database tuning exercises for learning? |
|
Jan 18 |
answered | Is the SQL Server IsShutdown property useful to determine whether a database is in a good state? |
