Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,806 through 20,820 (of 59,072 total)

RE: check how many rows delete updated per day and store it in another table?

Thanks. I guess I should ask the interviewers why they would want to do such a thing without it being a full blown audit of the table with a...
--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)

May 9, 2015 at 7:43 am

#1796803
RE: To create the trace for CPU and memory performance

bubby (5/8/2015)
My Server is slow, I am planning add the memory and CPU as it is virtual, I just want track the performance just for those 2 things, will 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)

May 8, 2015 at 7:50 pm

#1796786
RE: check how many rows delete updated per day and store it in another table?

super48 (5/8/2015)
how to track how many rows updated or deleted per day in a single table
and load the information in another table .
please help with this.
Your turn. Why...
--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)

May 8, 2015 at 6:59 pm

#1796785
RE: SQL server OS name

Richard Fryar (5/8/2015)
You can do this with PowerShell.
And if you have xp_cmdshell enabled (not encouraged for security reasons)...
What security reasons? If an attacker gets into your system without "SA"...
--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)

May 8, 2015 at 6:57 pm

#1796784
RE: NEED TO REMOVE DUPLICATES IN FLATFILE

Kannan Vignesh (5/8/2015)
that is fine. but remove duplicates in flatfile itself..?
The absolute best way is to have the people that are creating the flat file do their jobs better 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)

May 8, 2015 at 6:49 pm

#1796783
RE: Are the posted questions getting worse?

TomThomson (5/8/2015)
Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is dynamic sql?
Who is John...
--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)

May 8, 2015 at 6:35 pm

#1796782
RE: Why does TRUNCATE TABLE hang?

Scott-144766 (5/7/2015)
I've had the same symptom occur on a SQL 2012 machine. SSMS Tools was installed which has an option to block TRUNCATE statements, so that might be worth checking...
--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)

May 8, 2015 at 6:32 pm

#1796780
RE: Are the posted questions getting worse?

Lynn Pettis (5/8/2015)
I do love showing people Jeff's DelimitedSplit8K function and pointing them to his article.
:blush: I'm honored, ol' friend. It's not mine though. We've all made...
--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)

May 8, 2015 at 4:26 pm

#1796764
RE: Are the posted questions getting worse?

Lynn Pettis (5/8/2015)
Jeff Moden (5/8/2015)
SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is dynamic sql?
Who is John Gault?
Interesting...
--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)

May 8, 2015 at 4:23 pm

#1796763
RE: Are the posted questions getting worse?

SQLRNNR (5/8/2015)
Lynn Pettis (5/8/2015)
Geez, now someone doesn't even understand that the code they are running generates and runs dynamic SQL.
What is dynamic sql?
Who is John Gault?
--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)

May 8, 2015 at 3:57 pm

#1796752
RE: Are the posted questions getting worse?

Lynn Pettis (5/8/2015)
I must be getting cynical. Too many people are losing the ability to think for themselves and solve problems needing everything handed to them on silver platters.
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)

May 8, 2015 at 3:44 pm

#1796744
RE: Finding Problem Code

Steve Jones - SSC Editor (5/1/2015)
david.gugg (5/1/2015)
We run a daily trace that captures SQL running longer that X seconds. This gives us a good idea of what SQL can...
--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)

May 8, 2015 at 7:52 am

#1796587
RE: Tips to Optimize Your SQL Statements - Part 2

I have to remind everyone that changing a database to the SIMPLE Recovery Model is one of the very worst things you can do if Point-In-Time Backups are in effect...
--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)

May 8, 2015 at 7:44 am

#1796581
RE: Archieving Data

Understood. I'd have just done it all in T-SQL. The more I see about SSIS, the less I like it. Just a personal preference for me. ...
--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)

May 7, 2015 at 8:41 pm

#1796451
RE: Help Needed in Relational Logic

born2achieve (5/7/2015)
Hi,
Sample data to play with
use Temp
Go
declare @master-2 table(ID int, EmplopyeeID int);
declare @Releation table (IdRelation int idenity(1,1) primary key, ParentID int,ChildID int)
declare @Logic table(ID int,name varchar(20),company varchar(20),Salary money,ValidUser bit);
insert into...
--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)

May 7, 2015 at 8:27 pm

#1796450

Viewing 15 posts - 20,806 through 20,820 (of 59,072 total)