Viewing 15 posts - 106 through 120 (of 325 total)
I'd probably use FOR SYSTEM_TIME BETWEEN xxx AND yyy and then JOIN that on your dimension table.
September 10, 2018 at 4:42 pm
As is often the case with SQL Server, it depends. For small numbers of rows, statistics likely won't make any difference and can indeed hurt query performance due to SQL...
September 10, 2018 at 11:16 am
In this particular case it is still a 32-bit system and most queries against it are ultimately driven by factors like "first Monday in march 2016" etc so the date...
September 6, 2018 at 6:19 am
If the table is "hot" (that is getting updated/scanned a lot) then chances are most (or all) of the data is pretty much permanently in memory cache. 200 million rows...
September 6, 2018 at 12:45 am
I'd never do it with date and time values, it just becomes impossible to query in a useful fashion as you say and I can't see any situation that would...
September 5, 2018 at 10:19 pm
Because the data entirely fits in a VC(255). Redirecting errors via Bulk Insert only redirects rows that don't comply with the Format File. Once that is processed, it just does...
September 5, 2018 at 9:10 am
You need to set MAX_LENGTH on all the FIELD elements in the format file or OpenRowset/Bulk Insert just assumes they will work.
September 4, 2018 at 10:31 pm
September 4, 2018 at 9:58 pm
You could just do:
Select cola, colb, colc From SmallTable
Except Select cola, colb, colc From LargeTable
September 3, 2018 at 12:32 am
coolchaitu - Sunday, September 2, 2018 6:46 AMThanks Jeff..curious to know SQL Server has load balancing feature
There are multiple systems such...
September 2, 2018 at 7:10 am
coolchaitu - Saturday, September 1, 2018 11:22 PMBecause it is a e-commerce website like Amazon. There are millions of writes
If you're...
September 2, 2018 at 2:33 am
Session A is making multiple changes to a table. Very quickly SQL Server will have moved from row locks, onto page locks and ultimately will simply take a full table...
September 2, 2018 at 1:42 am
You appear to be joining on the "code" column of the first query, where you should be joining on the "band no"
September 1, 2018 at 6:12 am
If you're trying to insert a whole bunch of rows and redirect "incorrect" ones according to some ruleset, you may well find SSIS is a better choice since it is...
August 31, 2018 at 4:34 pm
The theory was that the average user doesn't need to run scripts, so Windows just shouldn't do it. And anyone running scripts (or in an environment where someone in control...
August 31, 2018 at 1:03 pm
Viewing 15 posts - 106 through 120 (of 325 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy