Viewing 15 posts - 6,526 through 6,540 (of 59,070 total)
As I have said - old values no longer needed, this recommendation is not really applicable
Actually, if you go back and read, I'm talking about the mess you might...
August 23, 2020 at 9:04 pm
Hello All, I want to learn the SQL course but I want to gain basic information about this course or looking for an online course also. Can anyone know...
August 23, 2020 at 7:10 pm
My question would be... "This is good but how could you do this from a job in SQL Server"?
August 23, 2020 at 7:03 pm
Only enforcing uniqueness by an identity column PK is my No. 1. Simple, but see it all the time and the disastrous consequences.
By the same token, it's also too...
August 23, 2020 at 6:55 pm
As a bit of a side bar, it also appears that you're logged in using the "sa" login... that means that you've broken some serious security rules and, unless you...
August 23, 2020 at 6:34 pm
Hi,
I want to remove ;# coming from SharePoint . The first and last occurrences should be removed and if there are more than one values then I want to...
August 23, 2020 at 6:24 pm
Jeff Moden wrote:Considering that it's exactly 1 hour off, I'm thinking this is some sort of Daylight Saving Time issue.
I'm sorry, Jeff, but I am lost by this comment.
Heh... I...
August 23, 2020 at 6:10 pm
...at every iteration comes at a much greater cost than doing it correctly in the first place.
True DAT!!! What's amazing to me is how many people, even seriously senior...
August 22, 2020 at 6:49 pm
Considering that it's exactly 1 hour off, I'm thinking this is some sort of Daylight Saving Time issue.
August 22, 2020 at 6:46 pm
closed
Why did you delete the text in your original post? Even if it turned out to be a dumb question that you found the answer to, a followup answer...
August 22, 2020 at 6:43 pm
Hello guys, i have table like blue area, how to query get result like green area
Just in case you don't know what people are talking about,...
August 22, 2020 at 6:42 pm
Table has 30 million rows, 11 GB in size, I need to alter one column from INT into BIGINT. I need to keep downtime to 10 min max.
Presently there...
August 22, 2020 at 6:35 pm
Not sure if this has been done, but I thought I'd have a little fun on a rare day off:
The MSSQL DBA's Prayer:
Our Master, which art in DataCenter
Two-part be...
August 22, 2020 at 1:45 am
The problem with this approach is that you no longer have a dynamic report where the user can select the date range. You have a fixed report for a...
August 22, 2020 at 1:42 am
@JeffModen - although your code works in SQL Server, it will not work in an expression in an SSRS report.
Missed the fact that this was an SSRS...
August 20, 2020 at 10:33 pm
Viewing 15 posts - 6,526 through 6,540 (of 59,070 total)