Jeff Moden

Forum Replies Created

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

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
RE: should we use json or xml in sqlserver.

GilaMonster (8/7/2016)
Jeff Moden (8/7/2016)
For example (and I'll admit I've not looked it up in the last 2 months or so), I'm pretty sure that the use of NOLOCK hasn't 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 7, 2016 at 1:48 pm

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

pedrolopezmail (8/7/2016)
Looks like using azure automation and a runbook is the prefer way for WindowAzure. You will need to know powershell to execute the SQL command. like invoke-sqlcmd.
https://drive.google.com/open?id=0B0S1Vqb-7RcfelBBejdFMWxFYzQ
https://drive.google.com/open?id=0B0S1Vqb-7RcfWGhZUXRsekpUSjA
Heh......
--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 10:31 am

#1894228
RE: Query Suddenly Performing Badly

TheSQLGuru (8/7/2016)
...more importantly they REALLY should be DOING proper statistics updates.
+ 1,000,000!
--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 10:29 am

#1894227
RE: Performance Tuning with SQL Server 2014 Standard

As a bit of a sidebar, unless you've made the mistake of shrinking your database, which causes the worst kind of fragmentation possible, fragmentation usually isn't what really costs you...
--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 10:26 am

#1894226
RE: Cleanse This - windows-1252 and utf8

p.s. SQL Server can't actually handle UTF-8 until you get to 2016.
--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 9:36 am

#1894223
RE: Cleanse This - windows-1252 and utf8

The "gibberish" in the data looks more like possible punctuation or special character marking. It looks like it may a "simple" code page problem.
--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 9:30 am

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

The Dixie Flatline (8/6/2016)
Eirikur Eiriksson (8/6/2016)
The Dixie Flatline (8/6/2016)
Answer withdrawn because I prefer not to answer interview questions.
Just curious, how do you determine that this is an interview question?
😎
I don't...
--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 8:55 am

#1894218
RE: Performance Tuning with SQL Server 2014 Standard

Adding memory will almost always help some but there's really only one way to fix this problem and everyone tries to avoid it with trickery that usually doesn't work. ...
--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 6, 2016 at 10:58 am

#1894193
RE: how to put nolock with tabel alies

rajemessage 14195 (8/6/2016)
hi,
which one is good way of putting nolock
other think is
Omitting the WITH keyword is a deprecated feature: This feature will be removed in a future version of Microsoft...
--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 6, 2016 at 10:47 am

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

rajemessage 14195 (8/6/2016)
hi,
in sql server 2016 json has been introduced, i wanted to know
, should we change to jsaon and leave xml.
because we are keeping configuration in xml 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 6, 2016 at 10:22 am

#1894191
RE: Query Suddenly Performing Badly

lmarkum (8/5/2016)
Kevin and Jeff: Thank you both for the time you have spent on this thread.
I did find 165 indexes that had the NO_RECOMPUTE option on 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 6, 2016 at 10:01 am

#1894190

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