Viewing 15 posts - 9,301 through 9,315 (of 59,078 total)
Yes I thought of LTRIM - just wasn't sure how to do it with this query:
That was my main question and you've not answered it yet. Why on...
May 12, 2019 at 12:51 am
Hello Team, I'm getting the following error: BACKUP failed to complete the command BACKUP DATABASE db name. Check the backup application log for detailed messages. In our system...
May 11, 2019 at 11:16 pm
To personify what Sergiy stated, I worked for a company that insisted that they didn't need native backups because they were doing "San Snapshots" every 20 minutes. I insisted that...
May 11, 2019 at 9:44 pm
The lessons of loss just don't rub off until someone experiences the issue themselves. No idea how to teach this, other than to provide some examples and try to...
May 11, 2019 at 9:10 pm
I'm doing a precon at Columbus. SPEND YOUR MONEY!!!!!
Heh... Grant is fantastic at teaching but sucks when it comes to self promotion or promotion for a cause. 😀 :D...
May 11, 2019 at 8:32 pm
Thank you I will try this.
You really need to answer the questions about how many indexes there are. You'll also need to identify how many foreign keys there are. ...
May 11, 2019 at 8:02 pm
This almost works: WHERE ModelName0 NOT IN ( SELECT value FROM String_Split(@Job_numbers, ',') ) But when you run the query it builds a list, but after the first row...
May 11, 2019 at 7:56 pm
In other news, what do you do when 2 CLI languages for your OS's isn't enough: Introduce a third: https://devblogs.microsoft.com/commandline/introducing-windows-terminal/ I admit I haven't read too far...
May 11, 2019 at 3:42 pm
Jeff - Destination is unknown, we just need to place file in network location in specific format requested by destination team.
There could be a serious advantage in doing this...
May 11, 2019 at 1:44 pm
Just to be sure, are you talking about Columbus or Pittsburgh? I'm assuming "Columbus" because i don't believe Pittsburgh has announced yet.
Columbus, Pittsburgh would be a...
May 10, 2019 at 11:07 pm
Is there a way to monitor network bandwidth on a SQL Server? My network admin is telling me that we r using over 1 terabyte of bandwidth per hour...
May 10, 2019 at 4:18 pm
Hi, I manage a server and would like to know is there a way of placing a small message that sits in view of all users connected to a...
May 10, 2019 at 4:12 pm
Well that's just DUCKY!
Is that a good thing, a bad thing, or are you just "quackin' up"? 😀
Signed up (hotel and everything!) for this SQL Saturday, and...
May 10, 2019 at 1:14 pm
It's known as an "Upsert" or a "Merge".
What IS the final destination here?
May 10, 2019 at 1:10 pm
What indexes do you have on the tables? Please post an actual execution plan for the query (the .sqlplan file, not just a picture, please). John
Great suggestion that worked very...
May 10, 2019 at 1:07 pm
Viewing 15 posts - 9,301 through 9,315 (of 59,078 total)