Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,371 through 8,385 (of 59,072 total)

Reply To: ASCII Text Dump

steve.casey wrote:
Suppose you have column ID in table T. Try the following:
Select ID, CAST(ID as Varbinary(255)) as Hex From T.
I find this to be sufficient in almost every case (and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 12, 2019 at 2:32 pm

#3697058
Reply To: Upgrade to SQL 2017 new server- how to copy over logins & Jobs during upgrade

andreas.kreuzberg wrote:
Hi,
just take a look to dbatools.io.
With a few commands you are able to copy database, jobs and logins from server a to server b.
It is realy simple.
Kind regards,
Andreas
If you're...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 12, 2019 at 1:41 pm

#3697020
Reply To: Are the posted questions getting worse?

Shifting gears a bit, have a look at the original post on the following thread (no need to pile on.. I'm just confused) ...
https://www.sqlservercentral.com/forums/topic/conversion-failed-when-converting-the-varchar-value-to-data-type-int-4
The OP posted this early on...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 12, 2019 at 6:20 am

#3696927
Reply To: Very large t-log with backups

Thank you for the thoughtful reply. Indexes can be a load of "fun", especially when they belong to 3rd parties that have such things a VARCHAR(1) and other datatype attrocities.
You...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 12, 2019 at 4:52 am

#3696923
Reply To: Very large t-log with backups

Greg Goss wrote:
@JeffModen,
Okay, I know it took longer than expected, but I finally got my hands on the code that updates that table. Here's the process. Once a record has been...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 9:07 pm

#3696867
Reply To: Relational Table SQL Query Optimization/Performance Issue?

ScottPletcher wrote:
To help resolve this problem across the board, for all your queries, you really need to re-cluster the CommoditySupplier table. This is a classic case of the "default clustering...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 4:23 pm

#3696777
Reply To: Need Split delimiter string into columns Solution

Jeff Moden wrote:
satishrao wrote:
Hi Jeff ,
I'm using SQL Server 2012. I just need to split the values and bring in a select statement. I don't want to insert them anywhere.
The see...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 4:10 pm

#3696771
Reply To: CPU frequently Maxing out 100%

Prior to doing a fail over, see if there are any Killed/Rolled Rollbacks.
If there are, I'd say there's a 99.5 % chance that you've been bitten by a problem with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 4:04 pm

#3696768
Reply To: Always on In PC

Thomas Rushton wrote:
Yes, you can do it using something like VirtualBox on your PC - but you'll need to have plenty of RAM and spare disk space. There are various...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 3:45 pm

#3696756
Reply To: Need Split delimiter string into columns Solution

satishrao wrote:
Hi Jeff ,
I'm using SQL Server 2012. I just need to split the values and bring in a select statement. I don't want to insert them anywhere.
The see the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 3:12 pm

#3696747
Reply To: Need Split delimiter string into columns Solution

satishrao wrote:
Hi Guys ,
I have column with Values like 1111\123132\34342323\1212. I used the above code to split it . But this doesn't work. The code returns blank. Can you please...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 1:54 pm

#3696708
Reply To: Incorrect date from control table

I don't know much about SSIS but, if I had to guess, I'd say that the 1900 date has absolutely nothing to do with file names. I'd say that SSIS...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 1:26 pm

#3696701
Reply To: Execute a procedure with parameter from table, one by one

p.s. You might want to post the stored procedure and the contents (or a least a sample of) the control table. See the first link in my signature line below...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 1:21 pm

#3696699
Reply To: Execute a procedure with parameter from table, one by one

christoph.kauflin wrote:
thanks for your answer. I googled batch mode and I guess I need some more experience and knowledge before I'd be able to transform my code into batch mode.
Probably...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 1:19 pm

#3696697
Reply To: How to Dynamically roll-up column results

shani19831 wrote:
Hi Jeff
Yes the datatype is represented that way within the DB.
I'm also worried about Policy and BatchMonth. I will talk to the Database Administrator as Policy should be Char while...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

November 11, 2019 at 1:10 pm

#3696694

Viewing 15 posts - 8,371 through 8,385 (of 59,072 total)