Viewing 15 posts - 5,626 through 5,640 (of 59,068 total)
Such a list exists in SQL Server in the sys.syslanguages system compatibility view
Much better idea 🙂 That will also bring to light, and allow checking for, any month...
February 13, 2021 at 3:01 pm
Everyone's already addressed the SSN and I'm glad it was hypothetical. Kristin hit the nail on the head regarding the PK. The only thing I'd say to watch out...
February 13, 2021 at 4:57 am
From the Article:
The SQL Server community has shared, inspired, and supported each other in a way I haven't seen in other areas.
You're one of the people that started that, Steve. ...
February 13, 2021 at 4:48 am
If each individual file is not language specific (i.e. dates within the file are mixture of languages) my inclination would be to extract all the DISTINCT month names, ideally...
February 13, 2021 at 4:12 am
Does anyone know of a method to try and convert dates into a us-english format?
Heh... I didn't until an hour or so ago. 🙂
This should help a bit. Don't...
February 13, 2021 at 4:02 am
Heh... might as well show that you're flexible, as well. Ask them if they want that in logical page order or physical page order. 😀
February 11, 2021 at 11:31 pm
yea we are on it for improving /re designing.
Until then is there a way to identify the ask?
You will never fix it if you do such a thing. It...
February 11, 2021 at 10:26 pm
...the name of the table should be a plural or collective noun and not a singular noun
If you're going to cite a spec, do it properly with Part, Section,...
February 11, 2021 at 10:20 pm
I agree @ken and @kristen
But is it even possible to get the first 25 and last 25 pages of data from the data pages since Data pages constantly keeps...
February 11, 2021 at 10:02 pm
It appears that you are performing QA testing on the production system - which to me is the root of the problem. For QA testing - a secondary system...
February 11, 2021 at 9:53 pm
Like I said above, changing the clustered index to support these DELETEs would certainly help these deletes A LOT. But, changing the clustered index without knowing "the rest of the...
February 9, 2021 at 4:12 pm
I can't help but notice the irony here.. Interesting question coming from someone with a handle of "sqlguru". 😉
Maybe you should change your handle to SQL God cos...
February 9, 2021 at 3:39 pm
I agree with allowing customization of logos, colors, taglines, etc.
I think you can have any logo, color, taglines you want provided that it doesn't shed any negativity on the...
February 9, 2021 at 3:25 pm
I just checked my system. That setting is on and, apparently, defaults to being on.
February 9, 2021 at 3:53 am
I can't help but notice the irony here.. Interesting question coming from someone with a handle of "sqlguru". 😉
February 8, 2021 at 10:31 pm
Viewing 15 posts - 5,626 through 5,640 (of 59,068 total)