Jeff Moden

Forum Replies Created

Viewing 15 posts - 21,766 through 21,780 (of 59,098 total)

RE: How to calcualte date Difference In Months?

First of all, you need to define what is meant by "the difference in months" because I'm pretty sure that you didn't mean for the following to represent a whole...
--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)

January 23, 2015 at 7:29 am

#1772615
RE: Just an idea ...

Doesn't Intellisense do what you want here? Or are you looking for the datatype and constraints, etc, as well?
--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)

January 23, 2015 at 7:24 am

#1772612
RE: Repeat contact cursor

gconte 55278 (1/22/2015)
Sorry about that, I provided the results instead of everything. Iv'e added the four missing fields on the attached.
That's nice but please see the first link under...
--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)

January 22, 2015 at 11:19 pm

#1772496
RE: Audit strategy on a separate database.

Putting your audit table on a separate database has some serious advantages and won't degrade performance at all.
Putting your audit table on a separate server with or without any form...
--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)

January 22, 2015 at 11:14 pm

#1772494
RE: Use of Function with update

rash3554 (1/22/2015)
This is the code I have
Begin
SET NOCOUNT ON;
DECLARE @RowCount1 INTEGER;
UPDATE dbo.Employee set dbo.fnFormatAddress(Address) = Address
where EmpCountry='USA'
...
--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)

January 22, 2015 at 11:10 pm

#1772491
RE: Use of Function with update

rash3554 (1/22/2015)
I don't think we have are approved to use CASS in our company.
Thanks
R
The answer is always "No" until you ask. 😉
--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)

January 22, 2015 at 11:03 pm

#1772488
RE: using charindex

Scott Coleman (1/22/2015)
Your string can be turned into valid XML with three REPLACE functions, then you can use XML functions to do all the parsing. Assuming none of 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)

January 22, 2015 at 10:33 pm

#1772484
RE: Remove Duplicates in opposite columns

For the long haul, I'd suggest modifying the code to always put the smaller of the two IDs in ID1, a check constraint on ID1 that enforces ID1 <= ID2,...
--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)

January 22, 2015 at 10:22 pm

#1772482
RE: What is the best practice about maintain and using Big Log Database

Looking at your questions, the answer to all of them is "It Depends" because you haven't told us what that "Main Table" is being used for. Is that 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)

January 22, 2015 at 10:17 pm

#1772481
RE: What are First Steps for a dba in new Office?

sm_iransoftware (1/22/2015)
THX All
and dba-120883, About your reply.
In step 5 :
#5. Baseline the System
- Use tools like Performance Monitor, SQL Profiler, Active SPID Performance
1- Which Counters Do I control in performance...
--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)

January 22, 2015 at 10:10 pm

#1772479
RE: What are First Steps for a dba in new Office?

Actually, I'm totally wrong. The 2 most important things are...
1. Locate the coffee machine.
2. Locate the Men's Room.
😛
--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)

January 22, 2015 at 10:01 pm

#1772478
RE: Are the posted questions getting worse?

WayneS (1/22/2015)
Jeff Moden (1/22/2015)
WayneS (1/22/2015)
Any Threadizens going to either the Austin or Cleveland SQL Saturday? I'd love to meet up with you!
I've need seen you since you got your MCM....
--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)

January 22, 2015 at 9:30 pm

#1772477
RE: compress existing backup file?

ericb1 (1/22/2015)
any help is appreciated, I have a SQL 2012 enterprise server, and I'm using Commvault as my backups. So commvault can restore a .bak file to my 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)

January 22, 2015 at 8:15 pm

#1772469
RE: Custom Aggregations (Measuring Headcount Attrition).

Perhaps a simplified version of the method in the following article would do. It would also help a lot with other things you might ask of the hierarchical data.
http://www.sqlservercentral.com/articles/T-SQL/94570/
--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)

January 22, 2015 at 8:01 pm

#1772466
RE: Please explain what this Trigger query does

To add to my suggestions on the Employee table, I just don't understand the need for a "ChangeType" column in the Employee table unless it means something totally different than...
--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)

January 22, 2015 at 7:55 pm

#1772463

Viewing 15 posts - 21,766 through 21,780 (of 59,098 total)