Viewing 15 posts - 3,496 through 3,510 (of 49,552 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)
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
March 3, 2016 at 5:12 am
8 year old thread (and confirmed as fixed by the OP)
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
March 2, 2016 at 11:11 am
szejiekoh (3/2/2016)
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
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...
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
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...
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
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.
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
March 2, 2016 at 9:09 am
Is there another table that has a list of distinct CUSTOMER_ID?
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
March 2, 2016 at 9:06 am
On this site. See 'articles' in the left-side menu.
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
March 2, 2016 at 7:48 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
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
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...
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
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...
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
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...
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
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.
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
March 1, 2016 at 5:29 am
And no GUI for Extended Events (or any of the newer 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
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...
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
March 1, 2016 at 4:48 am
Viewing 15 posts - 3,496 through 3,510 (of 49,552 total)