Forum Replies Created
Viewing 15 posts - 8,926 through 8,940 (of 59,078 total)
-
Reply To: What is wrong with my code?
In case anyone is interested, here's a typical example of my code at work. It's just a small example but you'll be able to derive the casing I use, other...
-
Reply To: week startdate and enddate
adisql wrote:hi,
looking for script to populate all the weeks in current year like below.
Any suggestions please.
How often do you need to do this? ...
-
Reply To: Is it worth to create different users for DBAs if they are doing the same job?
I whole heartedly agree. Each DBA must have their own login for accountability purposes. I'll also state that each DBA login must be an Active Directory login that follows enforced...
-
Reply To: Having trouble with wildcard/len syntax validation query
An stop using [A-Z] for this if these are GUIDs. It should be "[A-D] if your server is case insensitive and {A-Da-d] if your server IS case sensitive.
A better question...
-
Reply To: Cannot create a row of size XXXX which is greater than the allowable maximum row size of 8060
This isn't going to work even with VARCHAR(MAX) because each VARCHAR(MAX) requires that a 24 byte pointer be stored in the Clustered Index or the Heap and 24*500 = 12,000...
-
Reply To: How to split string without delimiter into multiple rows
Your test data doesn't match what you posted in your question. In your question, you have 3 provider columns. In your test data, you have 5 provider columns AND your...
-
Reply To: Are the posted questions getting worse?
Lordy... even though your recovery was simple that still had to be a PITA to recover from, Tom.
As for me not doing the Windows updates... I agree. I'm the luckiest...
-
Reply To: The Problem Solver
Frank W Fulton Jr wrote:I consider myself very fortunate. My father (Professional licensed engineer), saw my potential and from the age of about 6 had me help him fix things around the house;...
-
Reply To: Different VARCHAR output under SQL2016
souLTower wrote:In looking at it further I think I'm barking up the wrong tree. Thanks
How so?
My suggestion was going to be to first question as to why such special...
-
Reply To: SQL Server 2019 CTP 3.2 Available
I approach new releases with seriously mixed emotions.
For example, the move from 2000 to 2005 brought some great and incredibly useful changes to SQL Server. The Windowing Functions are a...
-
Reply To: Are the posted questions getting worse?
Asking a similar question to "Are the posted questions getting worse", I have to ask "Are the posted questions getting fewer". I know it's summer time and the number of...
-
Reply To: Detecting Detached Databases
AllegedDBA wrote:I know this an older thread, but in case anyone's still looking, Chrissy and Friends over at dbatools.io have it covered: https://docs.dbatools.io/#Get-DbaDbDetachedFileInfo
I could certainly be incorrect but...
-
Reply To: The buffer type is not valid. Make sure the Pipeline layout and all components
Because of my "love" for SSIS and curly-braced languages, I was going to suggest the ever obnoxious "clear the cache" suggestion that so many Windows folks make but, doing just...
-
Reply To: What is wrong with my code?
michael.leach2015 wrote:Jeff Moden, The vertical alignment of the code looks very nice. I can see how it is much easier to read. What do you mean with SSMS doing vertical...
Viewing 15 posts - 8,926 through 8,940 (of 59,078 total)