Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,386 through 8,400 (of 59,091 total)

Reply To: SQL'De Yedek alirken %90 da hata veriyor ve mdf dosyasi erisilemez diyor

Not sure in this case but I'd be tempted to say that the LOGO database is corrupt or actually. First thing I'd do is execute DBCC CHECKDB on it to...
--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 3:24 pm

#3697079
Reply To: Any SQL developer volunteers needed?

You're already on one of the greatest projects there is. Start answering questions on the these forums. You won't find a broader range of real life problems to solve anywhere...
--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 3:05 pm

#3697074
Reply To: Learning from Exercise

john.brooking wrote:
I've been cycling to work, 5 miles each way, for over 17 years now, and I feel about it all the ways you talk about your running. Five miles...
--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 3:03 pm

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

BWAAAA-HAAA-HAAAA!!!! I LOVE the cartoon! Thanks for the great laugh!
--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:56 pm

#3697066
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

Viewing 15 posts - 8,386 through 8,400 (of 59,091 total)