Viewing 15 posts - 796 through 810 (of 2,658 total)
Yes, sorry. My reply was before I realized that this data is already stored inside SQL Server. I wouldn't bother making a new table for it when a view will...
July 8, 2021 at 9:53 pm
For fun, I tried running the query you had pasted and it runs fine on my system.
My guess is you copy-pasted that from another site that does some formatting on...
July 8, 2021 at 9:49 pm
PLEASE DISREGARD THIS POST. OTHERS REPLYING TO THIS ARE DOING A MUCH BETTER JOB ON THIS THAN THE BELOW ADVICE.
I agree with Jeffrey here - I would create a table...
July 8, 2021 at 9:45 pm
I agree with ratbak here. You need some way that SQL can order the data that makes logical sense.
One HUGE problem with using the names of numbers is that it...
July 8, 2021 at 9:33 pm
I would like to add to what Eric said.
I think your test case is flawed. You are not simply testing if having the LDF and MDF on different disks is...
July 8, 2021 at 8:55 pm
Ours fall into ZZartin's bucket too - if the new bug is low impact or low probability of reproduction or low risk, we tend to not roll back. If the...
July 8, 2021 at 4:44 pm
Since it is a JOIN, if that JOIN is on the PK/FK column, it may be already indexed. If it isn't, you MAY get a boost by indexing on that...
July 8, 2021 at 2:16 pm
If you want a single, minimum value returned, don't group the data.
July 7, 2021 at 8:20 pm
For me, a rollback occurs when the release is having a high financial impact on the company. All of the releases I do are for internal-only tools and systems and...
July 7, 2021 at 3:42 pm
If memory serves, CXCONSUMER wait type is related to parallelism. So, my approach to fix this is to adjust parallelism.
Your options are pretty limited on how to fix it (from...
July 7, 2021 at 3:17 pm
SSMS, in the "results to Grid" mode will strip off any special characters when presenting it to the UI. What I mean is if you have a NEW LINE in...
July 6, 2021 at 9:25 pm
To me this looks like 2 different issues. The first issue I expect is being caused by trying to take a full backup with INIT on top of an existing...
July 6, 2021 at 9:03 pm
First thing I'd check is your data source. Any chance that those values are in fact blank and not tied to the user?
There are 2 ways to check this, one...
July 6, 2021 at 8:42 pm
If you reach out to support, don't be too surprised if they can't help you too much. I've had mixed results with support. Sometimes they are amazing, sometimes they come...
July 6, 2021 at 5:37 pm
For those wondering, I checked and those do not appear to exist on 2008 R2. So thinking they were added in 2012.
July 6, 2021 at 3:41 pm
Viewing 15 posts - 796 through 810 (of 2,658 total)