Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,071 through 17,085 (of 59,067 total)

RE: I need number of transaction / read / write handled by prod SQL server per second.

p.s. All of the character based columns in the return from this system view are NCHAR(128). Most of the values returned are quite a bit less. 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)

August 10, 2016 at 7:55 am

#1894781
RE: I need number of transaction / read / write handled by prod SQL server per second.

I don't use SQL Server code (T-SQL) for such a thing. Instead, I use Performance Monitor, which can both save the data in a nice, importable CSV and 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)

August 10, 2016 at 7:49 am

#1894776
RE: Sorting the document map

eobiki10 (8/10/2016)
Hi All,
Anyway to sort how items appear in document map. The items are already sorted in Table but when they appear in document map, the sorting disappears.
Thanks
Emma
I'm not sure...
--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 10, 2016 at 7:23 am

#1894770
RE: SELECT INTO vs INSERT INTO on Columnstore

Joseph M. Steinbrunner (8/8/2016)
Irish Flyer (6/9/2015)
Your article is incomplete without adding that a SELECT INTO is considered a DDL statement and completely locks both source and target tables for 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 9, 2016 at 2:57 pm

#1894661
RE: Count the occurrence of word in a Resume Table

BWAAA-HAAA!!!! Even the machine must sense it's the wrong thing to do. 😛
--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 9, 2016 at 2:48 pm

#1894658
RE: Finding related records within the same table

The Dixie Flatline (8/8/2016)
Hey Jeff, are you going to use your Hierarchies on Steroids approach? 🙂
That's what I was thinking. Gotta look at what's been posted a bit...
--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 8, 2016 at 8:10 pm

#1894451
RE: Finding related records within the same table

drew.allen (8/8/2016)
Here are the two queries that I was alluding to.
Thanks for taking the time to post that, Drew. I appreciate it very much.
Lynn Pettis (8/8/2016)
I came up 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)

August 8, 2016 at 8:03 pm

#1894450
RE: Quickest way to move jobs

william.scott 34593 (8/8/2016)
Thanks Jeff, do you have a similarly easy way to get the SSIS Jobs scripted out?
Thanks In Advance
bill
Only if the jobs are executed by SQL Server Agent, in...
--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 8, 2016 at 7:59 pm

#1894449
RE: Count the occurrence of word in a Resume Table

shambhavi13 (8/8/2016)
You are absolutely right... but the idea here is just to tag the candidate with skills like JAVA(6), C++(5) .. where 6, 5 is the number of keyword occurrence.
That'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)

August 8, 2016 at 7:44 pm

#1894448
RE: t-sql 2012 use a trigger

Lowell (8/7/2016)
TheSQLGuru (8/7/2016)
If you do this with a trigger, you MUST make it asynchronous!! I would either put the necessary information into a simple queue-style table or use SQL Server...
--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 7, 2016 at 4:24 pm

#1894255
RE: should we use json or xml in sqlserver.

The Dixie Flatline (8/7/2016)
Sorry for the drama guys. Totally my fault.
I vaguely remember a similar debate about this many years ago. The purpose of these...
--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 7, 2016 at 4:22 pm

#1894254
RE: Quickest way to move jobs

VastSQL (8/7/2016)
You can script out all jobs at once by listing the jobs in object explorer details-->select all jobs--> right click -->script jobs
+1.
For those that don't know how to get...
--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 7, 2016 at 2:17 pm

#1894245
RE: Performance Tuning with SQL Server 2014 Standard

mikes84 (8/7/2016)
Jeff,
That's some interesting insight. I don't think I would have necessarily thought updating one was more important than updating the other. I'll make sure to ensure statistics get updated...
--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 7, 2016 at 2:11 pm

#1894243
RE: t-sql 2012 use a trigger

pietlinden (8/7/2016)
Lowell brings up an interesting point that I totally forgot about. tightly coupling data insertion/triggers with e-mail can cause your inserts to fail if your mail server fails....
--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 7, 2016 at 2:02 pm

#1894242
RE: t-sql 2012 use a trigger

To repeat what I stated on the following forum for this exact same question...
http://forums.sqlteam.com/t/t-sql-2012-trigger-and-generate-email-message/7349/2
Wouldn't it be easier to just prevent the duplicate "record" to begin with?
Apparently SQLTeam.Jassie1 = SSC.Wendy Elizabeth.
--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 7, 2016 at 1:59 pm

#1894241

Viewing 15 posts - 17,071 through 17,085 (of 59,067 total)