Viewing 15 posts - 4,126 through 4,140 (of 49,552 total)
And what if the full backup that completed successfully won't restore? Completing doesn't mean it's good. If you're using RESTORE VERIFYONLY, that checks the header of the backup file only.
So,...
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
December 1, 2015 at 1:27 pm
For CPU usage, use perfmon. It can track per core, for a specific process or overall.
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
December 1, 2015 at 12:26 pm
BACKUP ... WITH INIT;
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
December 1, 2015 at 12:25 pm
Could be a maintenance plan, a linked server (loopback linked server perhaps)
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
December 1, 2015 at 12:25 pm
No, it's not.
Running CheckDB on Server 3 tells you about the integrity of the DBs on server 3 only. The IO subsystem doesn't write to the transaction log when it...
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
December 1, 2015 at 12:24 pm
Check the application being used to access SQL and see what it's logging in as. If it's Windows Authentication, then it'll be something like <domain>\<logged in user> or <computer>\<logged in...
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
December 1, 2015 at 11:29 am
I said nothing about deny, and it's nothing to do with the computers being used.
A login to SQL Server starts with no permissions. So take the login that's being used...
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
December 1, 2015 at 11:18 am
Give the login that's used rights to access only the DB that it should be able to see and no other permissions. By default a login has no permissions at...
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
December 1, 2015 at 11:05 am
No, but generally a better (easier, less prone to errors) way of getting a DB from SQL 2008 to SQL 2012 is backup/restore. Is that an option?
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
December 1, 2015 at 11:01 am
Perfmon files are pretty small, I usually use the default of 15 seconds, run for a day or two and end up with a file in the tens of megabytes.
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
December 1, 2015 at 10:55 am
They want detail? How many rows are we talking about? If it's over a hundred or so, they're not going to be reading the data. Maybe worth taking some 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
December 1, 2015 at 7:45 am
Most new features will work fine in a lower compat. It's just places where what is allowed has changed, like with APPLY where things will break on a lower compat...
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
December 1, 2015 at 7:05 am
All that can be determined from the error is that it's some app on the machine 123.45.67.89. If that's the active node of the cluster, then there is something running...
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
December 1, 2015 at 6:35 am
Ed Wagner (12/1/2015)
GilaMonster (12/1/2015)
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.
Probably something to do with collapsing the quantum mechanical wave function. Using one...
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
December 1, 2015 at 6:08 am
Ed Wagner (12/1/2015)
They appear to have a one-shot use though, before disappearing to somewhere else.
Probably something to do with collapsing the quantum mechanical wave function. Using one collapses the function...
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
December 1, 2015 at 5:32 am
Viewing 15 posts - 4,126 through 4,140 (of 49,552 total)