Viewing 15 posts - 271 through 285 (of 26,487 total)
I've written an entire book on this topic (Joe Celko's SQL programming style, ISBN 9780120887972). No, I am not going to post 200+ pages of text; you can get...
December 10, 2019 at 8:46 pm
I work for a British company. We've had developers in AUS work for us
Understandable since Redgate did acquire an Australian firm and incorporated their technologies into their products. When...
December 10, 2019 at 6:53 pm
Because we are always looking and Allstate does let tech employees work from home (subject to certain caveats, depending on the division)… Careers @ Allstate.
Parsons also encourages remote...
December 10, 2019 at 3:41 pm
As to pay cuts, I took a pay cut to work for SQLServerCentral. At the time, Andy, Brian and I were thinking to sell or do something because the...
December 9, 2019 at 8:04 pm
I am starting to ramp up my job search at this time, initially looking to see what may be available in house first.
This is something I'm going...
December 9, 2019 at 4:32 pm
one of the things i'm constantly told,... keep it to 2 pages
That is a good idea. Sometimes, however, that can be difficult.
For those just starting out, trying to keep...
December 9, 2019 at 4:29 pm
I am starting to ramp up my job search at this time, initially looking to see what may be available in house first.
This is something I'm going to...
December 9, 2019 at 4:14 pm
Lynn
I was thinking that if you show them that if you contribute to the community then you get the Rockstar job. lord alone, look at Grant, he gets flown...
December 9, 2019 at 3:41 pm
Sam - did you read my comments?
Adding those indexes are not necessarily what needs to be done (as recommendations from the engine are just that)
and is the field...
December 9, 2019 at 3:32 pm
I suspect that they are someone who is way in over their head, and uses places such as here to "do their job".
Just to be a contrarian,...
December 9, 2019 at 1:49 pm
You really wonder why your query is slow? Have you actually looked at the execution plan?
Issues I found after a quick look at some of the information you provided.
December 9, 2019 at 12:04 am
This is the index I would create:
CREATE NONCLUSTERED INDEX [idx_moss_plotsampleid] ON [dbo].[moss]
(
[plot_sample_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE =...
December 6, 2019 at 9:12 pm
Is it me or do I still not see it?
Edit: Nevermind
December 6, 2019 at 5:52 pm
One way, put it in a zip file, or rename it to Trouble_Level100.txt. It is actually just an XML file.
December 6, 2019 at 5:47 pm
Eirikur - Sure I've attached the plan running at Level 100.
This area of SQL, I am very much still learning. I can spot some stuff, but I'm still gaining...
December 6, 2019 at 4:56 pm
Viewing 15 posts - 271 through 285 (of 26,487 total)