Viewing 15 posts - 121 through 135 (of 1,243 total)
I did have a solution that worked without a calendar table but I spotted a mistake.
It's probably worth pointing out that there is no 31st of June.
October 16, 2019 at 2:26 pm
SQL Saturday in Edinburgh - 1st Feb, anybody from here thinking about going?
Haven't been to Edinburgh since I was about 14, but planning to go there next...
October 7, 2019 at 7:26 am
We have a table with one column as UTC and another as local time. So far this hasn't caused any (major) problems but I'm pretty sure that it will bite...
October 3, 2019 at 7:22 am
There are, essentially, no moving parts or complex electronics to go wrong. It just works.
I would suggest that you look a little closer. There are a hug number of...
October 1, 2019 at 7:11 am
The Mark I mirror is a device where the phrase 'if it ain't broken, don't fix it' is extremely apt. There are, essentially, no moving parts or complex electronics to...
September 30, 2019 at 8:38 am
I used to have a pair of running shorts with a key pocket at the back. One morning I waved my wife off to work, took a look at the...
September 30, 2019 at 8:05 am
Yes I agree this website is slowing down. Not just performance but activity as well.
On another topic of slow...here was this last weekends goods from the smoker.
August 28, 2019 at 8:27 am
It's transactional replication. We do rebuild indexes on the publisher but they shouldn't get replicated. The other reason this is unlikely is the timings of the growth events doesn't coincide...
August 8, 2019 at 6:57 pm
And they've changed their minds.
August 8, 2019 at 6:41 pm
Inquiring minds want to know, how many Threadzians are affected by this one?
I'm not sure that it's the kind of thing that will affect many people immediately. It's going...
August 8, 2019 at 7:14 am
It is indeed possible to do that. In a nutshell, you need to add the 'OverallTotalPages' built-in field to a header or footer on your report. There's more detail here.
July 25, 2019 at 7:36 am
While it does depend, in general I'd think that while the DBA might be not responsible for those design items, they likely will be held accountable for them....
July 24, 2019 at 1:21 pm
I got the same results as Carlos.
It logically makes sense that because there has been no net change the differential will only be small but the outcome of my test...
June 17, 2019 at 8:14 am
March 28, 2019 at 6:36 am
Viewing 15 posts - 121 through 135 (of 1,243 total)