Viewing 15 posts - 5,926 through 5,940 (of 49,552 total)
You can only have one default instance on a machine. An installation will create 0 or 1 instances, depending on what is selected. If an instance is installed, it can...
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
May 15, 2015 at 6:08 am
Thanks all.
Next step, chat with management so that there are no unpleasant surprises, then start making some changes. And some plans. And some <redacted> :hehe:
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
May 15, 2015 at 5:37 am
Don't.
Hints are for rare cases. They're for when you absolutely are sure you know better than the query optimiser on the best plan for a query and you know 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
May 15, 2015 at 3:14 am
Kinda, but not really. You can force a plan, the USE PLAN hint, but it doesn't mean that it'll use a specific plan in cache, rather that the optimiser will...
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
May 15, 2015 at 2:57 am
That's not a SQL Server query. Looks more like MySQL (the limit). You'll probably get better answers on a MySQL forum as this one is dedicated to Microsoft SQL Server.
Try...
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
May 15, 2015 at 2:32 am
Which cache? There are several of them
All caches can be explicitly cleared, other than that what kind of manipulation are you interested 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
May 15, 2015 at 2:31 am
The second query will only return rows where the doTableDate is exactly 03/01/2014 00:00:00, because the upper and lower limits of the BETWEEN are the same
What do you want 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
May 15, 2015 at 2:17 am
Chris Wooding (5/15/2015)
Enya? When the database is down? Surely it has to be Motorhead?
Definitely Enya. When the situation is very stressful, the last thing I want is music that's going...
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
May 15, 2015 at 2:15 am
Huh?
Could you perhaps be a little more specific as to what's wrong?
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
May 15, 2015 at 12:04 am
Does a consistency check return any errors? If so, what errors?
DBCC CheckDB ('<database name>') with no_infomsgs, all_errormsgs
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
May 14, 2015 at 11:55 pm
Of course you can take backups of the principal.
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
May 14, 2015 at 11:53 pm
CodeGuys (5/14/2015)
Please gothrough below link,
There are a number there that are wrong. They're great for figuring out who, in an interview, went memorising questions from 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
May 14, 2015 at 11:50 pm
dwain.c (5/14/2015)
I gotta wonder what the ANSI standards say about this one!
Perfectly legal afaik.
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
May 14, 2015 at 11:48 pm
afw (5/14/2015)
GilaMonster (11/6/2013)
Can also happen if someone starts a restore and stops the restore part way through (perhaps realising they were restoring over the wrong DB).
Could you tell me 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
May 14, 2015 at 11:47 pm
Alan.B (5/14/2015)
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
May 14, 2015 at 9:19 am
Viewing 15 posts - 5,926 through 5,940 (of 49,552 total)