Viewing 15 posts - 2,056 through 2,070 (of 49,552 total)
Create a role that has DENY SELECT on that table, assign that role to the users. As long as they don't have sysadmin access, they will not be able to...
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
November 22, 2016 at 5:27 am
JasonClark (11/22/2016)
You check on this link:
Sure (that's the same link Phil provided). First paragraph:
You can upgrade from SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server...
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
November 22, 2016 at 5:15 am
That wait usually has nothing to do with the network. In most cases it's the client app that's slow to consume the data. Management Studio is a particularly large offender...
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
November 22, 2016 at 12:55 am
JasonClark (11/21/2016)
Yes you can do 'In place upgrade'
No, he can't. There's no in-place upgrade option for SQL 2005 to SQL 2016. See the link that Phil posted.
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
November 22, 2016 at 12:53 am
hurricaneDBA (11/21/2016)
Hi GailThis is the script i am using and i did include checkpoint and now its showing up as NOTHING
Its ok to include it right?
.....
GilaMonster (11/21/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
November 21, 2016 at 6:23 am
No, I'm not saying you need to include CHECKPOINT in your maintenance scripts, you don't. Checkpoints run on a regular interval, they're background processes.
I showed you that just to answer...
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
November 21, 2016 at 6:08 am
hurricaneDBA (11/21/2016)
The biggest one was this morning at 6am at 11gb but after that the sizes vary from 4MB to 6MB now
I would suggest running them every half an...
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
November 21, 2016 at 5:31 am
hurricaneDBA (11/21/2016)
The hourly transaction logs vary in size from 4mb to now it's 12GB
Well that's the answer to why your log is growing.
If your log backup is 12GB, that...
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
November 21, 2016 at 4:58 am
The question here is why the log grows to 1.5GB.
How big is the database?
How big are your hourly log backups files for this 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
November 21, 2016 at 4:46 am
hurricaneDBA (11/21/2016)
What would cause the value log_reuse_wait_desc to not update?
I already answered that.
The value shows what prevented one or more VLFs from being marked reusable last time log truncation was...
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
November 21, 2016 at 4:42 am
hurricaneDBA (11/21/2016)
And is there a way to mark the VLFs manually for reuse?
Um, no. If a VMF can't be marked reusable it's because one or more log records are...
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
November 21, 2016 at 3:59 am
You can create a DDL trigger to roll back the DROP PROCEDURE, but if the user has CREATE & DROP permissions on the database, they'll be able to drop 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
November 21, 2016 at 3:08 am
hurricaneDBA (11/21/2016)
Why isnt the value being changed to NOTHING after a maintenance plan is run?
Because the value shows what prevented one or more VLFs from being marked reusable last time...
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
November 21, 2016 at 3:07 am
homebrew01 (11/18/2016)
Are there any "gotchas", or special considerations I need to consider ?? TIA
The main one is whether SQL 2016 will install on the OS that you have....
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
November 19, 2016 at 1:36 am
Sql_In_Seattle (11/18/2016)
However, if we back that database up then immediately restore it to the same server (with a different name) the restored database is consistently corrupt on page 1:10
Yup, because...
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
November 19, 2016 at 1:26 am
Viewing 15 posts - 2,056 through 2,070 (of 49,552 total)