Viewing 15 posts - 3,871 through 3,885 (of 49,552 total)
Login with Windows authentication and be logged into windows with the account that you installed the instance as. Part way through the installation it would have prompted you for windows...
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
January 9, 2016 at 4:58 am
lw1990 (1/8/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
January 9, 2016 at 4:54 am
Because it's not an explicitly granted permission. It's part of what CONTROL SERVER grants (which is basically sysadmin rights). You can DENY the right, and the DENY will overrule 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
January 8, 2016 at 2:08 pm
You don't need to create a new database and then restore over. Doing so is why you got an error, the database in the backup didn't match t\he one you'd...
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
January 8, 2016 at 1:42 pm
Edit: nm
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
January 8, 2016 at 1:39 pm
er.mayankshukla (1/8/2016)
in a non unique non clustered index, the clustered key comes to leaf and non leaf...
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
January 8, 2016 at 1:32 pm
mxy (1/8/2016)
Query runs fast, what does CPU time represent.
It's the number of milliseconds that the query spent actually executing (as opposed to
Can we convert that value to a...
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
January 8, 2016 at 1:31 pm
A couple things
The waits are cumulative since SQL started. So unless you're taking snapshots and comparing them, a change won't appear to have had any effect because there's all 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
January 8, 2016 at 1:21 pm
True, I overcomplicated things a little.
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
January 7, 2016 at 12:40 pm
KGJ-Dev (1/7/2016)
I am struggling to make it where to put like operator and where to put '%' at the end
The = should have been a LIKE, sorry about 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
January 7, 2016 at 12:20 pm
Look at the two pieces I gave you. The one I said you can't do is what you're trying. So take the one I said you can do (which is...
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
January 7, 2016 at 11:29 am
The thing to remember is that the output of the CASE statement is an expression, not a piece of code. That is, it's something that you could put after a...
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
January 7, 2016 at 10:50 am
Looking at the score, you probably missed it by one or two questions.
For aggregates, read up and practice group by, the aggregate functions (sum, count, min, max, etc), practice using...
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
January 7, 2016 at 8:40 am
Siberian Khatru (1/7/2016)
- Was the test I took a fair representation of what I can expect on my free retest from a subject matter perspective?
Probably yes. You'll get a...
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
January 7, 2016 at 8:26 am
Won't be related to TempDB. If it was, the temp table one would have performed badly as well.
It probably comes down to row estimations. With local variables, the optimiser can't...
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
January 7, 2016 at 2:16 am
Viewing 15 posts - 3,871 through 3,885 (of 49,552 total)