Viewing 15 posts - 3,496 through 3,510 (of 49,571 total)
What column in your table defines which user is the 'last' one?
Can you post table definitions and sample data please (as CREATE TABLE and INSERT statements)
March 3, 2016 at 5:12 am
8 year old thread (and confirmed as fixed by the OP)
March 2, 2016 at 11:11 am
szejiekoh (3/2/2016)
March 2, 2016 at 9:25 am
szejiekoh (3/2/2016)
GilaMonster (3/2/2016)
szejiekoh (3/2/2016)
T3 - user created some objects (will this objects be recorded in system database ?)
No, they will not be in the system databases.
The system DBs store database...
March 2, 2016 at 9:20 am
szejiekoh (3/2/2016)
T3 - user created some objects (will this objects be recorded in system database ?)
No, they will not be in the system databases.
The system DBs store database info (what...
March 2, 2016 at 9:16 am
Grant Fritchey (3/2/2016)
Anycompletedtransactions that are currently in the log are what get backed up.
Uncommitted also get backed up.
March 2, 2016 at 9:09 am
Is there another table that has a list of distinct CUSTOMER_ID?
March 2, 2016 at 9:06 am
Well a transaction log is just a backup of the transaction log, and so there's no need to know what's changed to do that.
For differential backups, google: differential change map
March 2, 2016 at 7:44 am
With a 2TB database, I wouldn't worry about 35GB of log file. It's not large. Hell, I had a 250GB log file several years ago for a 1TB database (and...
March 2, 2016 at 2:51 am
kc2ine (3/1/2016)
I have like 89% of server 20GB RAM used all the time.Is it normal usage?
Perfectly normal
Any way to limit RAM for SQL Server so the Windows got more?
Set...
March 2, 2016 at 2:25 am
I didn't ask you to run it with repair! I asked for a normal checkDB with NO_INFOMSGS so I can tell you how severe the damage is, and whether repair...
March 1, 2016 at 10:39 am
szejiekoh (3/1/2016)
So which account should I use to install SQL server ?
One that has administrative privileges on the server. That's all that's needed.
March 1, 2016 at 5:29 am
And no GUI for Extended Events (or any of the newer features)
March 1, 2016 at 5:06 am
It's Index ID 1, it's a clustered index.
What you've got there is an orphaned LOB page. LOG data types are stored off-row, and this one is not referenced by any...
March 1, 2016 at 4:48 am
Viewing 15 posts - 3,496 through 3,510 (of 49,571 total)