Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,556 through 30,570 (of 59,101 total)

RE: CAST vs CONVERT or another solution?

SQLKnowItAll (3/28/2012)
S_Kumar_S (3/28/2012)
I too executed your query several times on a development server. Depending on load, either of them worked faster but the tests never convinced me that one is...
--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)

March 28, 2012 at 7:01 pm

#1466124
RE: How to remove minutes and seconds from DateTime?

dwain.c (3/27/2012)
A search of this forum should probably have yielded this solution which I've already posted:
SELECT DATEADD(hour, DATEDIFF(hour, 0, '2012-03-27 12:57:21.097'), 0)
No need to use CAST or CONVERT!
🙂
--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)

March 28, 2012 at 6:31 pm

#1466117
RE: What is the best SQL Server disaster recovery solution?

I prefer "SAN replication" when possible.
--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)

March 28, 2012 at 6:20 pm

#1466116
RE: vbscript to delete old backup files

gmamata7 (3/28/2012)
Is there any methods available to delete old backup file other than Maintenance plan?
I have to ask "Why"? The Maintenance plan deletes work just fine. Why 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)

March 28, 2012 at 6:13 pm

#1466113
RE: Shrink log file if at a certain percentage...

John Waclawski (3/28/2012)
I'm reading a lot about the "evils" of log file shrinking. It shouldn't really be done but sometimes it's a "necessary evil" to be used to take...
--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)

March 28, 2012 at 5:50 pm

#1466109
RE: Find special characters

peter90west (3/28/2012)
novated lease
SPAM Reported.
--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)

March 28, 2012 at 5:04 pm

#1466095
RE: Pivot Data

vani_r14 (3/28/2012)
[font="Tahoma"]Since it's Varchar and not Integer am unable to use the Aggregate functions.
Absolutely not true. Use MAX.
--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)

March 28, 2012 at 4:59 pm

#1466090
RE: Upgrading server w/ t-byte data

Any chance of bringing up a new server and migrating the data instead?
--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)

March 28, 2012 at 3:49 pm

#1466057
RE: Which one is faster?

Munabhai (3/28/2012)
create table omar.dbo.a123
(
contactid char(10),
firstname varchar(20),
emailaddress varchar(20)
)
CREATE NONCLUSTERED INDEX IX_NC_PresidentNumber
ON omar.dbo.a123 (EmailAddress)
Let's assume,...
--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)

March 28, 2012 at 3:45 pm

#1466052
RE: Need help to query a non-normalized database

{EDIT} Sorry... I didn't scroll down to see my own post. I already responded to Pieter'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)

March 28, 2012 at 3:30 pm

#1466040
RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

MyDoggieJessie (3/27/2012)
I didn't think about the fact that because the file was an attachment it might keep you from opening it
It's not that I couldn't open it. In order...
--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)

March 28, 2012 at 6:14 am

#1465609
RE: Primary Key: GUID vs. INT

HowardW (3/27/2012)
The point of GUIDs is that they're globally unique, so you can have multiple unconnected client/middle tiers that can safely generate an ID without worrying about collision with other...
--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)

March 27, 2012 at 9:48 pm

#1465449
RE: I need my columns to trim off a few pounds...!

SQLRNNR (3/27/2012)
SQL_Enthusiast-AZ (3/27/2012)
Thank you Everyone,
The REPLACE worked; however, after running the query, I found thousands records with all kinds of non-numeric values. That's is a lot of REPLACE(REPLACE(REPLACE...
So, I turned...
--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)

March 27, 2012 at 9:30 pm

#1465446
RE: Vendor Selection

My description of most 3rd party software is very simple. "Over promised, under delivered." Of course, I feel that same way about 1st and 2nd party software, as...
--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)

March 27, 2012 at 9:28 pm

#1465445
RE: A Developer's scalar UDF is takeing this query from 3 seconds to over 5 minutes to run

MyDoggieJessie (3/27/2012)
Hey Jeff, thanks for that (really)...just not certain how I would work your splitter into what I already have posted a couple posts above...
With using the CTE's that GSquared...
--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)

March 27, 2012 at 9:13 pm

#1465443

Viewing 15 posts - 30,556 through 30,570 (of 59,101 total)