Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,621 through 16,635 (of 59,067 total)

RE: Blocking by Insert

Rechana Rajan (10/16/2016)
Found the below query causing blocking from different SPID.
declare @0 bigint,@1 bigint,@2 varchar(50),@3 bit,@4 varchar(50),@5 datetime2(7),@6 varchar(50),@7 datetime2(7)
INSERT [dbo].[Transaction]
([TransactionId], [ConId], [TransactionStatus], [Status], [CreatedUserId], [CreatedDate], [UpdatedUserId], [UpdatedDate])
VALUES (@0, @1,...
--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 16, 2016 at 3:41 pm

#1906788
RE: How to get the maximum value per row?

Heh... crud. JLS is faster then I am. His post wasn't there when I started mine.
--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 15, 2016 at 2:36 pm

#1906763
RE: How to get the maximum value per row?

This should do it...
SELECT tbl.CKey, ca.VX
FROM #Counter tbl
CROSS APPLY (SELECT MAX(VX) FROM (VALUES (CA),(CB),(CC),(CD),(CE))v(VX))ca(VX)
;
The FROM (VALUES) combination in the CROSS APPLY effectively unpivots each...
--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 15, 2016 at 2:35 pm

#1906762
RE: A Load Of Old Cobols

Heh... forget the old stuff. It'll persevere and someone somewhere will know how to fix it or be able to science it out. It's a part of why it's...
--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 15, 2016 at 2:24 pm

#1906759
RE: Transaction log is not truncated even after log backup in FULL recovery model

naren.ece2012 (10/15/2016)
Actually in our environment, we have 310 Gb of production database in that we have 200 Gb of data files and 110 GB of log files.The log space has...
--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 15, 2016 at 2:17 pm

#1906758
RE: update trigger get fields before and after update

I would never use CHECKSUM for such a thing. It's much too easy for it to equate two things that are not equal because it's just a simple binary...
--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 14, 2016 at 5:40 pm

#1906730
RE: Bones of SQL - Practical Calendar Queries

whenriksen (10/14/2016)
You made me curious and its been a quiet day.
SELECT COUNT(*),
CAST(DATEADD(WEEK, DATEDIFF(WEEK, '20061231', DATEADD(DAY, 7
- CASE DATEPART(WEEKDAY, o.modify_date) 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)

October 14, 2016 at 5:33 pm

#1906728
RE: Bones of SQL - Practical Calendar Queries

ScottPletcher (10/14/2016)
whenriksen (10/14/2016)
First day of the business week is Monday.
What do you recommend?
I posted code that did that type of calc already. What specifically are you trying to list?
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)

October 14, 2016 at 5:28 pm

#1906727
RE: Help: Truncate tables with same prefix

CELKO (10/13/2016)
But a better question is why is a date, which is an attribute of an entity, being used as metadata?
It's probably not applicable for this thread but 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)

October 13, 2016 at 7:04 pm

#1906494
RE: BULK INSERT - Access denied

This sounds like the Kerberos Double-Hop problem. What happens when someone with sysadmin privs runs the code from the server itself?
--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 13, 2016 at 6:51 pm

#1906493
RE: SQL Server v Access re:security

There are other "data security" matters, as well. You need to consider backups and where they live as well as "data at rest". That goes for both SQL...
--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 13, 2016 at 6:29 pm

#1906492
RE: Evaluate each field from source to target and update

hegdesuchi (10/13/2016)
Hi,
I have a request where i have to check if ID exists ,If ID exists then update. However client wants to evaluate each field from source and check 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)

October 13, 2016 at 6:21 pm

#1906491
RE: Temp tables or local tables

ps_vbdev (10/13/2016)
In my transform in my etl I have created permanent tables and prefixed them with "Temp" and i use these as stores to load data from the source system...
--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 13, 2016 at 6:09 pm

#1906489
RE: Enable and disable foreignkeys to insert data

komal145 (10/13/2016)
This is development enviornment and since data is not current need to enforce the data for my testing. Anyways i inserted data without enabling or disabling , just by...
--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 13, 2016 at 5:56 pm

#1906487
RE: query and compare values in a text based column

niall5098 (10/13/2016)
HI Jeff,
the original table does have a modified column so the idea is I would querying for data which has a modified date > getdate()-1
I'm certainly not an XML...
--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 13, 2016 at 9:20 am

#1906374

Viewing 15 posts - 16,621 through 16,635 (of 59,067 total)