Viewing 15 posts - 5,941 through 5,955 (of 49,552 total)
Firstly, never be too embarrassed to ask your colleagues. Everyone started from no where and you'll probably find that a couple of them also don't know what the predicate does...
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 7:59 am
Resolve what? It's an informational message, not an error.
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 7:02 am
Tom Brown (5/14/2015)
even Sci-Fi authors/books - on amazon click through, (I'm sure I remember picking up book recommendations from your site in the past)
That's kinda been there for...
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 6:47 am
Brandie Tarvin (5/14/2015)
An alternative is a "tipping jar" that some sites use (such as paypal link), or connecting up to Patreon (which some of the webcomics use).
Neither of which serve...
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 6:18 am
Please post query, table definition, index definitions and actual execution plan (saved as a .sqlplan file and attached)
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 6:04 am
To start, Always On is not a feature. It's a marketing term. The two features which fall under that marketing terms are Failover Clustering and Availability Groups. Which are you...
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 6:03 am
Question for the people here...
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I started...
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 5:55 am
aaron.reese (5/14/2015)
If the data contains MR, Mr or Mr. and it contains MRS, Mrs or Mrs. then it is two people
Careful, that makes large assumptions. What about
Prof and Mrs?
Mr and...
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 4:12 am
It is a nightmare and it's going to be near-impossible to do correctly in all cases.
What you can do is list all the valid titles that you have in 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 3:52 am
There aren't multiple ON clauses in a join there, it's not allowed. What's there is a rather badly formatted mess. It is NOT equivalent to a single join with ANDs,...
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 3:46 am
Thanks Paul.
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 2:28 am
Grant Fritchey (5/13/2015)
GilaMonster (5/13/2015)
Grant Fritchey (5/13/2015)
Because you can have physical corruption that doesn't get backed up or restored.
How?
I keep hearing this advice, but the problem is it doesn't bear out....
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 13, 2015 at 7:36 am
Grant Fritchey (5/13/2015)
Because you can have physical corruption that doesn't get backed up or restored.
How?
I keep hearing this advice, but the problem is it doesn't bear out. Backups are 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
May 13, 2015 at 7:25 am
Grant Fritchey (5/13/2015)
If you offload it to another server, you'll still want to run a PHYSICAL_ONLY check on the first server.
Why?
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 13, 2015 at 7:07 am
You can offload the work to a second server, restore a backup of the production DB and check that. You can break CheckDB down and run its pieces, that's CheckAlloc,...
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 13, 2015 at 6:36 am
Viewing 15 posts - 5,941 through 5,955 (of 49,552 total)