meta user
network profile
| bio | website | alirazeghi.com |
|---|---|---|
| location | Santa Monica | |
| age | 33 | |
| visits | member for | 8 months |
| seen | 2 days ago | |
| stats | profile views | 136 |
Lover of all things technology, history, classic art, politics (not mud slinging), with a specific fondness of databases and long walks on the beach :P
|
2d |
answered | How do I automatically deliver the SQL Server built in reports? |
|
2d |
comment |
Can I decrypt TDE transaction log files for use with 3rd party software? Is there any way to restore the DB first elsewhere? |
|
May 22 |
revised |
Backup very large table added 248 characters in body |
|
May 22 |
answered | Backup very large table |
|
May 14 |
comment |
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth? Your 'app' should have a windows username/password which sends the commands to the DB, not each user using the app. Unfortunately it's a design flaw. |
|
May 14 |
revised |
How to check if I am hitting the Express Edition size limit? added 119 characters in body |
|
May 14 |
comment |
How to check if I am hitting the Express Edition size limit? Yea but in this case, do you really think that'll be an issue where the end user just wants a db size count? I guess I shouldn't post it even in cases where the end user will absolutely see if it skipped the DB they are looking for so that it doesn't reinforce bad behavior. I'll just remove that part at this point, you're right, we don't need that command plastered anywhere else. |
|
May 14 |
comment |
How to check if I am hitting the Express Edition size limit? Thanks Aaron for the sysaltfiles, I didn't look into that one yet! sp_msforeachdb has lots of painful issues, but I figured for a SQL Express install where the guy just wants to run a query to see how much free space he has it's fine. |
|
May 14 |
revised |
How to check if I am hitting the Express Edition size limit? Added "Remember to add up all the 'SPACE_USED_MB' for each DB to get the total size." |
|
May 14 |
answered | How to check if I am hitting the Express Edition size limit? |
|
May 13 |
awarded | Caucus |
|
May 13 |
comment |
SQL Server 2012 Simple Recovery Model with LOG_BACKUP log_reuse_wait_desc I'm running 2012SP1 as well and haven't seen this issue yet.Could you humor me and just run this to double check select name, database_id, recovery_model_desc, log_reuse_wait_desc from sys.databases. Can you restore the DB to a different instance and test what happens there? |
|
Apr 26 |
comment |
Transactional Replication Concerns @Kin I would but I need rep on the parent site, my rep is mostly on dba.stackexchange.com. I'll message you after I get some of these prod issues fixed right now ;) |
|
Apr 26 |
comment |
Transactional Replication Concerns @Kin Hey!! Whatsup! Yes, I remember, what a pleasure to see you here. :) |
|
Apr 25 |
comment |
Transactional Replication Concerns Agreed, but the user seemed really new to replication based on his questions and just wanted to clarify that since it can really hurt if it happens. I did like your answer though, thanks for posting it. |
|
Apr 25 |
comment |
Transactional Replication Concerns Quick point on 2. - It could impact primary and cause it to fail. First the DISTRIBUTOR database will continue to fill up with unsent transactions. Once that fills up, the transaction log of the primary will continue to fill up. At that point you could have performance issues with log file fragmentation or cause all writes to fail if the disk fills up completely. |
|
Apr 24 |
comment |
ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT Great testing presentation. Thanks for the details +1 |
|
Apr 24 |
revised |
ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT added 322 characters in body |
|
Apr 24 |
revised |
ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT added 322 characters in body |
|
Apr 24 |
answered | ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT |
