Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,116 through 17,130 (of 59,067 total)

RE: How do we avoid junk in the VARCHAR fields ?

Luis Cazares (8/1/2016)
Maybe like this? Why do you have different validations for names and other values?
UPDATE [MEMBER].[IMP_MEMBER_INT]
SET
[ContactLastName] = CASE WHEN...
--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)

August 3, 2016 at 5:50 pm

#1893655
RE: Deadlock - due to Temp Tables?

Luminary1975 (8/3/2016)
The reason I'm asking is I appear to have the correct cumulative fix applied and I just got a deadlock on a temp. table... :crying:
Now THAT'S a horse of...
--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)

August 3, 2016 at 5:01 pm

#1893653
RE: Deadlock - due to Temp Tables?

Luminary1975 (8/3/2016)
Hello;
Thanks for your reply, but I don't believe the cause in the article is clear.
This issue occurs because the two sessions that are used to execute the stored...
--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)

August 3, 2016 at 3:31 pm

#1893637
RE: Deadlock - due to Temp Tables?

Luminary1975 (8/3/2016)
Hello;
Can anyone explain this issue in any more detail? Is it just an issue with Lock Manager or is it an issue with tempDB.
I cannot believe that there is...
--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)

August 3, 2016 at 8:46 am

#1893508
RE: Substring from RIGHT

Smendle (8/3/2016)
Jeff Moden (7/20/2016)
Smendle (7/20/2016)
Jeff Moden (3/4/2016)
John Mitchell-245523 (3/4/2016)
REVERSE the string, use SUBSTRING, and then REVERSE it again.
John
Got code?
Something like this?
With MyCTE(val)
AS
(
SELECT '9.0.0832.1032' UNION ALL --need to get the 32...
--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)

August 3, 2016 at 8:37 am

#1893501
RE: A twist on recursive query

michael.lock@aer.ca (8/2/2016)
Hello, and thank you to all of the respondents. I actually didn't think I was going to get anything, it had been a few days. I'm actually...
--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)

August 2, 2016 at 8:45 pm

#1893396
RE: A twist on recursive query

CELKO (8/1/2016)
Adam Mechanic had an improved technique. The only downside was that if the adjacency list had a cycle, it was bitch to find. The old stack algorithms could be...
--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)

August 2, 2016 at 8:43 pm

#1893395
RE: delete spamming Account please

Steve Jones - SSC Editor (8/2/2016)
Yes, and it's a fraction of the total posts each day. While it seems like a lot if you get the emails, it's not
It may...
--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)

August 2, 2016 at 8:24 pm

#1893394
RE: How to Run Scheduled Jobs in Azure SQL Databases

As a bit of a sidebar, I think that any system that allows for the use of a password "in the clear" is a really bad idea no matter 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)

August 1, 2016 at 5:49 pm

#1893095
RE: Datediff not recognised

Luis Cazares (8/1/2016)
Use the SSIS syntax.
DATEADD("dd", DATEDIFF("dd", (DT_DATE) "1900-01-01", GETDATE()) - 1, (DT_DATE) "1900-01-01")
Or, use a stored procedure to do the actual work and have SSIS call it. 😉
--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)

August 1, 2016 at 5:11 pm

#1893092
RE: login through machine name

tariq (8/1/2016)
Can user login to SQL Server using machine name instead of user login ID? I can create login with us\machinename$ but cannot get into SQL Server.
I seriously consider never...
--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)

August 1, 2016 at 5:10 pm

#1893091
RE: Shiny new server - split temp db files question

Eirikur Eiriksson (8/1/2016)
Quick question, have you set the TFs 1117 & 1118?
😎
Setting TF1118 is cool but setting TF1117 comes with some serious problems if you have partitioned tables that use...
--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)

August 1, 2016 at 5:06 pm

#1893090
RE: How do you turn off an instance of Azure?

So... Like I said... "Nukes". 😀
--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)

August 1, 2016 at 4:35 pm

#1893087
RE: massive i/o bottleneck

Unless you can guarantee that tables will be split across multiple separate physical spindles, splitting up an MDF file may actually slow things down even worse than they are now....
--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)

August 1, 2016 at 4:34 pm

#1893086
RE: Suggestions to Track Data

mbrady5 (8/1/2016)
Thanks for the reply. I created what I was looking to do.
What method(s) did you use?
--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)

August 1, 2016 at 4:18 pm

#1893085

Viewing 15 posts - 17,116 through 17,130 (of 59,067 total)