Viewing 15 posts - 6,091 through 6,105 (of 8,731 total)
Here are 2 more options that you could test. I'm not sure if they're any better, but at least they read the tables just once. The second one should be...
July 23, 2014 at 4:29 pm
What about using "|{CR}{LF}" as a column delimiter?
Then you can remove the additional carriage return on your last column in another step.
July 23, 2014 at 3:44 pm
You have 2 options:
- Normalize your table
- Use dynamic SQL
You decide.
July 23, 2014 at 2:57 pm
Gary Varga (7/23/2014)
TomThomson (7/23/2014)
July 23, 2014 at 1:37 pm
kimmedim (7/23/2014)
July 23, 2014 at 12:24 pm
The problem is that one query is summing the values before rounding and the other one is summing the values after rounding. You need to define which option do you...
July 23, 2014 at 11:23 am
Just to be clear, the file doesn't need to be on the same server as SQL Server. Typically, the files will be stored in a separate location and referenced by...
July 23, 2014 at 9:45 am
Seems like you have some stale statistics on worker_custom_field. Also, why are you using all those NOLOCK hints? Are you aware that you might get incorrect results that include duplicate...
July 23, 2014 at 8:53 am
Lots and lots of tables. It's hard for us because we don't know your schema and we can't test anything.
Try looking for columns that are defined as strings which are...
July 22, 2014 at 3:49 pm
July 22, 2014 at 12:41 pm
This sounds like homework. Designing a DB is a lot of work and you should go step by step with the design.
You have a good example with the AdventureWorks...
July 22, 2014 at 11:16 am
This solution might be slow for large volumes of data but does what you need. Any option will be slow because you have seven values in one column and that's...
July 22, 2014 at 10:51 am
Steve Jones - SSC Editor (7/21/2014)
We just thought we were part of the same team.
That's so important and the path to successful projects. When communication and/or collaboration stops, problems arise.
July 22, 2014 at 10:24 am
It's a nice article, short and simple.
However, I would have liked if you specified one of the main problems I've seen with beginners (including me) which is that the...
July 22, 2014 at 10:18 am
Are you measuring the time to retrieve the 4 million rows? or are you including the time to show them?
What are you expecting to get? if you're querying the full...
July 22, 2014 at 10:04 am
Viewing 15 posts - 6,091 through 6,105 (of 8,731 total)