Viewing 15 posts - 7,726 through 7,740 (of 49,552 total)
The algorithm used for SQL logins isn't documented.
Why do you need it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 1:14 pm
In this case no assumption was needed, since the OP said
Field from table1 is primary key
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 12:59 pm
If it happens consistently, schedule a server-side trace to start just before the problem occurs and run long enough to catch the entire thing, then you can review the trace...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 12:55 pm
Yes it should, because you have no explicit transactions.
In snapshot isolation, read queries will show the data version as of the time their transaction started. You have no explicit transaction,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 12:53 pm
Steve Jones - SSC Editor (9/22/2014)
It's back
Can I get my lost points back? :crying:
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 9:11 am
So the server is intended as a reporting/analysis server (read-only access to production data), not a development server (where developers are actively working on new features and changing existing features)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 8:47 am
But you wouldn't be doing it in those 30 hours. The advantage of the mirror/log shipping method is that you get the large copy done well in advance (weeks even)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 8:31 am
Snapshots are read only, log shipping secondaries are read only.
I have to ask, because the reason for needing up to date data will affect appropriate methods. If it's a reporting...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 8:26 am
If Field in Table1 is ever null, that query would return no rows. However since that's the primary key, it's not nullable and hence you don't have that concern
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 8:24 am
The DMV should be transactionally consistent. This isn't the sysindexes from SQL 2000 era which could be and was wrong at times.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 8:22 am
Either one will do, if it's a once-off (which it should be), it really doesn't matter which you use.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 8:08 am
If you log ship, then your dev database will be completely read-only. Mirroring's worse, the DB isn't accessible at all. Kinda defeats the point of a development server.
Why do you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 7:58 am
Nothing wrong with a disabled login owning objects or being the grantor of rights.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 7:54 am
Typically with something that size, I'd set up log shipping or mirroring before the planned migration day, then all I have to do on migration day is fail over the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 7:52 am
jralston88 (9/22/2014)
What's the impact?
None.
Putting it another way - I just modified a database, placing content over 4 files.
No you didn't. You changed one file to have an initial...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 22, 2014 at 6:35 am
Viewing 15 posts - 7,726 through 7,740 (of 49,552 total)