Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,116 through 11,130 (of 59,095 total)

RE: Need help in writing Query

Prakash-485822 - Sunday, September 30, 2018 6:25 AM
Need help in writing query. I table Requestdetails which contain the below data.
Pkey RequestId StateName ResolverGroup DateCreated
1 123 Resolved 29 9/27/18 15:16
2 123 Acknowledge 29 9/27/18 15:16
3 123 Assign...
--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)

October 1, 2018 at 7:09 am

#2007493
RE: Give Up on Natural Primary Keys

I've been through several bank acquisitions by other banks and how it affects our data. I WISH that people had been smart enough to use only the surrogate keys that...
--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)

October 1, 2018 at 6:55 am

#2007491
RE: Are the posted questions getting worse?

It was an absolute pleasure to meet you in person, Eirikur! Thanks for making the trip!
Sorry about my pictures... I actually was smiling! 😀
--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)

September 30, 2018 at 10:38 pm

#2007450
RE: Fitting Into RAM

christopher.ivens - Wednesday, September 26, 2018 10:17 AM
djackson 22568 - Wednesday, September 26, 2018 7:25 AM
--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)

September 26, 2018 at 6:28 pm

#2007176
RE: Fitting Into RAM

Steve Jones - SSC Editor - Wednesday, September 26, 2018 2:29 PM
christopher.ivens - Wednesday, September 26, 2018...
--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)

September 26, 2018 at 6:19 pm

#2007175
RE: How to use HASHBYTES function in sql server for multiple columns

vikasjagadale8 - Wednesday, September 26, 2018 12:38 PM
I appreciate the information about which algorithm to use. But any help on the actual...
--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)

September 26, 2018 at 1:10 pm

#2007147
RE: How to use HASHBYTES function in sql server for multiple columns

DesNorton - Wednesday, September 26, 2018 12:23 PM
Sorry for butting in, but the deprication is documented.
According to HASHBYTES (Transact-SQL)
Beginning...
--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)

September 26, 2018 at 12:54 pm

#2007146
RE: Renaming a Schema in SQL Server

Steve Jones - SSC Editor - Tuesday, September 25, 2018 11:29 AM
That's true. I didn't cover dependent objects. I assume if...
--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)

September 26, 2018 at 7:27 am

#2007075
RE: SQL Server stored procedures fast in SQL but slow when called by ASP.NET

jkramprakash - Wednesday, September 26, 2018 4:50 AM
i made some changes in the query.actually i created clustered index for three columns for...
--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)

September 26, 2018 at 5:56 am

#2007059
RE: Database email functionality

nimmagaddakrupanandh - Wednesday, September 26, 2018 1:40 AM
But if i gave my mail ID in reply email also ,that failled items table...
--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)

September 26, 2018 at 5:28 am

#2007053
RE: Fitting Into RAM

christopher.ivens - Tuesday, September 25, 2018 12:57 PM
We've been discussing REDUCING our RAM on a test box and leveraging the flash drives...
--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)

September 25, 2018 at 2:54 pm

#2007014
RE: SQL performance counter shows 0 as values

Does anyone know if any of the methods listed on this thread actually worked? We're suffering from precisely the same problem as what the OP originally posted. We can 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)

September 25, 2018 at 2:21 pm

#2007004
RE: SQL Server v.Next is Coming in 2019

Steve Jones - SSC Editor - Tuesday, September 25, 2018 11:44 AM
Summer90 - Tuesday, September 25, 2018...
--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)

September 25, 2018 at 1:10 pm

#2006993
RE: Are there such things as SQL heresies?

Eric M Russell - Tuesday, September 25, 2018 8:51 AM
When we speak of T-SQL "heresies", it seems we're speaking of anti-patterns. Some...
--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)

September 25, 2018 at 10:03 am

#2006943
RE: e-commerce company, planning to start a sale offer in december

coolchaitu - Tuesday, September 25, 2018 1:53 AM
Hi Experts,
We are a small e-commerce company, planning to start an offer in december....
--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)

September 25, 2018 at 9:34 am

#2006933

Pkey	RequestId	StateName	ResolverGroup	DateCreated
1	123	Resolved	29	9/27/18 15:16
2	123	Acknowledge	29	9/27/18 15:16
3	123	Assign...

Viewing 15 posts - 11,116 through 11,130 (of 59,095 total)