network profile
| bio | website | movingsql.com |
|---|---|---|
| location | New Jersey | |
| age | 55 | |
| visits | member for | 1 year, 1 month |
| seen | May 13 at 16:43 | |
| stats | profile views | 56 |
coder & programmer of many defunct languages...
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB We need some clarification on this: What exactly do you mean by "failed"? Windows users should transfer over without a problem unless there's a trust issue with the domain. What do you mean by "this is a Microsoft problem"? Is that your own conclusion or is that based on a known problem? |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB Oh, wait a minute. If this is just a DB transfer issue then there's are better/simpler way to do this ... |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB Are the users members of any Roles? Do the have any Granted or Denied access permissions to objects? Are they all Users associated with Windows Logins that are registered as server-principals? Do they have any granted DB or Schema privileges? |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB Is this really for both MySql and MS SQL Server? They very likely will be completely different procedures. |
|
Jan 3 |
comment |
SQL Server drop and create all users in every DB That's going to be a big problem if any of those users are the Owners of any objects. |
|
Dec 13 |
comment |
Cannot restore Amazon RDS SQL Server database to given point-in-time using SQL Server Management Studio Try scripting out the Restore command and then executing it from a query window. |
|
Dec 12 |
comment |
grant permission You only showed us the SQL commands and setup for the parts that work. Now you need to show us the same things for the user, groups and commands that do not work. |
|
Dec 10 |
comment |
Why Does the Transaction Log Keep Growing or Run Out of Space? Ack! You're right, I missed the last sentence of the Log Shipping section (I must be trying to read to fast). |
|
Dec 10 |
comment |
Why Does the Transaction Log Keep Growing or Run Out of Space? Oops, I now see that you already got the Replication thing... my bad. |
|
Dec 10 |
comment |
Why Does the Transaction Log Keep Growing or Run Out of Space? Great write-up Mike. Here's some additional stuff you may want to consider: Log Shipping: The backup period, delivery period and restore period do not have to be all the same, for example you can do log-backups every hour but still only restore once a day. Other (little known) Causes: Transactional Replication; the Log Reader will keep LSNs from being released until it has read them. So if something keeps the Log Reader from running, the Log file will keep growing. |
|
Oct 21 |
comment |
How to find out what caused a schema change? By "schemas" it means the metadata (i.e., Object Definitions), not the owner-schemas specifically. |
|
Oct 4 |
revised |
SSMS Tools Pack Alternative fixws title |
|
Oct 4 |
comment |
Calling stored procedure with select and update statement @Aaron: maybe you should add that as a request to connect? "Allow us to Rollback SELECT statements?" ;-) |
|
Oct 4 |
comment |
Is there any limit on how deep the Server Owner can access my data? "Yes, they can do whatever they want." |
|
Oct 4 |
suggested | suggested edit on SSMS Tools Pack Alternative |
|
Oct 4 |
answered | Visio 2010 and SQL 2012 - Reverse Enginnering |
|
Aug 31 |
comment |
Is it possible to increase query performance on a narrow table with millions of rows? Again, the index already existed. I just added three BIT columns to its leaf-level. That, I submit, is "not really significant". |
|
Aug 31 |
revised |
Is it possible to increase query performance on a narrow table with millions of rows? added 156 characters in body |
|
Aug 31 |
comment |
Is it possible to increase query performance on a narrow table with millions of rows? The overhead head for the covering index isn't really significant given that it's a narrow table and the "covering" is just an addition to the pre-existing index that already included most of the row. |
|
Aug 31 |
comment |
Is it possible to increase query performance on a narrow table with millions of rows? Yep, that's because it realizes that it can use the covering index to skip having to do the sorting for the ORDER BY. |
