Forum Replies Created
Viewing 15 posts - 6,526 through 6,540 (of 59,070 total)
-
Reply To: When updating INT to BIGINT do rows with nulls matter
migurus wrote: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...
-
Reply To: Best SQL Course in 2020
Ankitdixit wrote: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...
-
Reply To: Calling Procs from PowerShell with Parameters
My question would be... "This is good but how could you do this from a job in SQL Server"?
-
Reply To: Of Hedgehogs and Database Design
kuopaz wrote: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...
-
Reply To: getdate () brings me a different time than my operating system
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...
-
Reply To: Replace cpecial characters from SharePoint
PSB wrote: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...
-
Reply To: Of Hedgehogs and Database Design
Eirikur Eiriksson wrote:...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...
-
Reply To: Replace cpecial characters from SharePoint
Considering that it's exactly 1 hour off, I'm thinking this is some sort of Daylight Saving Time issue.
-
Reply To: How to collapse data?
wallywizard wrote: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...
-
Reply To: Sum query 12 month in year
mrsiro wrote: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,...
-
Reply To: When updating INT to BIGINT do rows with nulls matter
migurus wrote: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...
-
Reply To: Are the posted questions getting worse?
david.edwards 76768 wrote: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...
-
Reply To: Setting Start Date
Jeffrey Williams wrote: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...
Viewing 15 posts - 6,526 through 6,540 (of 59,070 total)