Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,776 through 23,790 (of 59,102 total)

RE: Performance related question

Wow! I'm not sure what I was thinking about when I wrote that mess. Looking back at it, it doesn't even make sense to me. :blush: I...
--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)

April 26, 2014 at 9:24 am

#1708968
RE: Need set based method to insert missing records into table - right join doesn't work

dmckro (4/25/2014)
My point exactly! Thank you for your response. I'll take a look at it this afternoon.
I think you missed the point. 😉
--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)

April 25, 2014 at 8:22 pm

#1708929
RE: Switch from prod DBA to BI Admin or Cloud?

Are you any good at the other 2 jobs?
--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)

April 25, 2014 at 8:17 pm

#1708928
RE: Is this normal Log file size?

smtzac (4/24/2014)
DB size 775 GB
Data file space usage 585 GB
log size 185 GB - according to SQLPERF
My question is this a normal logfile size of 585GB Datafile? any suggestions 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)

April 25, 2014 at 7:48 pm

#1708926
RE: Query help

What would you want in the following case?
drop table #temp
CREATE TABLE #temp
(
TotalAmt DECIMAL(10,0)
)
INSERT INTO #temp(TotalAmt) VALUES(30);
INSERT INTO #temp(TotalAmt) VALUES(40);
INSERT INTO #temp(TotalAmt) VALUES(60);
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)

April 25, 2014 at 7:35 pm

#1708925
RE: Replication Transactions per Second Benchmark

It's not really possible to predict such a thing. Even if you knew precisely how much SQL Server could handle, you still have switches and routers on the LAN...
--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)

April 25, 2014 at 7:31 pm

#1708923
RE: Create DML trigger for single table in SQL 2008 and send email alert to group

Robin35 (4/16/2013)
Thanks Steve,Lowell,L'eomot for your help and patience ....script is working fine now....i'm posting the entire script for people who might need it in future....
--/****** Object: Table [dbo].[logger] ...
--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)

April 25, 2014 at 7:11 pm

#1708921
RE: Create DML trigger for single table in SQL 2008 and send email alert to group

Ah, sorry. I was doing a little test and hit post instead of prview.
--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)

April 25, 2014 at 7:02 pm

#1708920
RE: How to split datafiles of a Database in to two

Before we can answer your question, why do you want to do the split to begin with? Your reasons will help determine the best method.
--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)

April 25, 2014 at 6:43 pm

#1708919
RE: Calculate average through recursive CTE

Brandie Tarvin (4/25/2014)
--You only need one DECLARE statement -- and you can assign the values within that statement too.
[font="Arial Black"]-- Saves on typing[/font]
"Sure you are? Dark Side powerful. ...
--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)

April 25, 2014 at 5:36 pm

#1708914
RE: Performance related question

Sorry folks. I'm not sure what I was thinking on this particular post and I've taken this particular entry down to make sure that no one would use it....
--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)

April 25, 2014 at 3:39 pm

#1708908
RE: New format of subject for notification emails

Ummmm.... Let's think about this... Why would email subject titles be searchable on Google to begin with? Makes no sense to 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)

April 24, 2014 at 2:01 pm

#1708590
RE: Need assistance with making a sproc SQL Injection proof

MarbryHardin (4/24/2014)
The bulk of the execution plan cost comes out to a clustered index scan on the primary table. It's more than sufficient for our needs.
If I get 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)

April 24, 2014 at 8:14 am

#1708418
RE: Auditor Rant

I'm going through a SOC 2 audit right now. My biggest problem is all of the repetative questions that they can't seem to correlate in the simple little minds....
--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)

April 24, 2014 at 8:11 am

#1708417
RE: Problem with SQL statement pulling out incorrect data

fuzzyjonclay (4/23/2014)
All sorted now. Thank you 🙂
2 way street here. How is it "all sorted now"? What did you end up doing???
--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)

April 23, 2014 at 9:46 pm

#1708294

Viewing 15 posts - 23,776 through 23,790 (of 59,102 total)