Viewing 15 posts - 6,796 through 6,810 (of 49,571 total)
That one is unique, because it's a PRIMARY KEY. It's the PRIMARY KEY which forces the column to be unique, not the identity. Identity just provides incrementing values.
January 14, 2015 at 2:12 am
syquil (1/7/2015)
We have...
January 14, 2015 at 1:28 am
Since CheckDB generates a snapshot and runs against that shapshot by default, manually generating a snapshot's not going to achieve very much.
Physical_Only means a lot of checks are skipped. While...
January 14, 2015 at 1:23 am
Not offhand, but a quick google search for articles on setting up log shipping should return a few hundred results.
January 14, 2015 at 1:18 am
hazeenahazu (1/13/2015)
row id is the unique index number of every row of table maintaining by database automatically...
January 14, 2015 at 1:14 am
The views you want are sys.partitions or sys.dm_db_partiton_stats.
January 14, 2015 at 1:09 am
You could call the files .txt and it would work the same. SQL doesn't care in the slightest what the extensions of its data files are.
January 13, 2015 at 7:31 am
To be honest, there's so much wrong that forums aren't going to be much help. You should probably see if you can find someone in your area that's willing to...
January 13, 2015 at 5:34 am
Well, they are. In the sense that Row Number exists and Row Index doesn't.
January 13, 2015 at 5:24 am
Maybe ask this on an MS Access forum, since this is quite obviously not SQL Server.
You also have several security flaws with this code. Passwords stored in plain text been...
January 13, 2015 at 4:32 am
Backup the entire DB (you can't back up specific tables), restore and drop the ones you don't need.
10 million rows isn't that large.
January 13, 2015 at 3:18 am
Erland Sommarskog (1/12/2015)
As I understand it, membership in sysadmin means that all permissions checks are waived.
Correct.
Any login that's a member of the sysadmin fixed server role bypasses ALL security checks....
January 13, 2015 at 1:51 am
Log shipping will work, you just have to have the destination DB RESTORING, standby isn't an option when there's a version mis-match.
January 13, 2015 at 1:46 am
Script all their modified procs, views, functions out. Backup, restore with overwrite. Run script with all objects (take a backup of their DB first, just in case)
Likely to be faster...
January 13, 2015 at 1:44 am
Please note: 8 year old thread
January 13, 2015 at 1:43 am
Viewing 15 posts - 6,796 through 6,810 (of 49,571 total)