Viewing 15 posts - 2,056 through 2,070 (of 49,571 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...
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...
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...
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.
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)
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...
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...
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...
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?
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...
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...
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...
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...
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....
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...
November 19, 2016 at 1:26 am
Viewing 15 posts - 2,056 through 2,070 (of 49,571 total)