4,133 reputation
11226
bio website sqlblog.com/blogs/…
location Chicago, IL
age
visits member for 2 years, 8 months
seen 9 hours ago

Developer


2d
awarded  Custodian
2d
reviewed Approve suggested edit on Database Design Help: MySql/PostgreSQL Single Database/Multiple Databases
Jul
25
comment Filling in missing dates in record set from generate_series()
to get more than 1 as count, add more test data.
Jul
25
comment Filling in missing dates in record set from generate_series()
@Mr.Concolato The previous version worked on 9.3. Fixed.
Jul
25
revised Filling in missing dates in record set from generate_series()
deleted 27 characters in body
Jul
25
answered Filling in missing dates in record set from generate_series()
Jul
25
accepted Should I shrink my database?
Jul
25
revised Should I shrink my database?
added 252 characters in body
Jul
24
comment Should I shrink my database?
Thank you for the links, but I am not sure they are completely relevant: they mostly assume that the data is going to grow back, such as "Do you ever shrink your data files? I’ve personally never been fond of it, especially for production databases. After all, they’ll simply have to grow again". This is not the case, they will not have to grow again.
Jul
24
revised Should I shrink my database?
added 102 characters in body
Jul
24
comment Should I shrink my database?
Regarding "You really need to find out at what pace it is growing" - I did. "Think about it - what are you going to do with the disk space that you gain from shrinking the database " - I already thought about it. I modified my question accordingly.
Jul
24
revised Should I shrink my database?
added 465 characters in body
Jul
24
asked Should I shrink my database?
Jul
22
awarded  Nice Question
Jul
2
awarded  Curious
May
24
awarded  Necromancer
Mar
27
comment Altering db schema in production environment
We do it all the time. Google up the following article "Developing low maintenance databases", it describes refactoring tables without downtime.
Mar
21
comment Get SSMS to show the time a query completed at?
You can just add one more select at the end of your query: SELECT GetDate()
Mar
4
comment Recommendations for a SQL Server 2014 Database Administrators Course
Almost all questions about IT "quickly become obsolete" - this industry in general is not as static as Mendeleev's Periodic Table or Newton's laws or Euclid's theorems. This " they quickly become obsolete" thing on this particular site does not sound completely right.
Feb
21
awarded  Nice Answer