Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,016 through 24,030 (of 59,099 total)

RE: sp_send_dbmail has formatting off on datetime when directing output to csv file

I think your biggest problem is that you're using a .xls extension on the file. It's NOT an Excel file. Also, if someone opens even a text file...
--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 1, 2014 at 4:26 pm

#1702276
RE: Get the hierarchy orders(top to bottom) of the table

My question would be, why do people insist on storing hierarchical data in multiple tables? It's usually SO much easier to store/maintain the data as a single adjacency list...
--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 1, 2014 at 3:59 pm

#1702270
RE: Error-CreateProcessAsUser on xp_cmdshell

Satheesh E.P. (4/1/2014)
XP_cmdshell is working fine in our environment with a non-sysadmin account.
I don't know about your specific problem but I have to tell you that giving a non-sysadmin account...
--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 1, 2014 at 3:55 pm

#1702267
RE: Copy DB from Prod to QA

New Born DBA (3/31/2014)
I did run into some problems and I am wondering if someone can tell me what to do.
I was unable to restore the DB because the DB...
--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 1, 2014 at 7:55 am

#1702043
RE: X in Technology

Stephanie J Brown (3/31/2014)
I think what skeleton567 may be trying to say is that the NAME of the group perpetuates stereotypes. [font="Arial Black"]If instead of "Women in Technology" 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 1, 2014 at 7:47 am

#1702035
RE: Are the posted questions getting worse?

jasona.work (4/1/2014)
Grant Fritchey (4/1/2014)
jasona.work (4/1/2014)
April 1st, the day when the internet loses its collective mind (did it ever have it to begin with?) and starts throwing out "jokes" (term used...
--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 1, 2014 at 7:25 am

#1702017
RE: Converting sequential time records into IN and OUT times

Thanks for the feedback. It'll let me get some sleep tonight because I was seriously trying to think of an easy way to handle that computationally but I've been...
--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 31, 2014 at 10:50 pm

#1701878
RE: DELETE FIRST 1000 ROWS

While some of the methods posted are ok, there's still the fundamental problem...
shashianireddy (3/29/2014)
I WANT DELETE FIRST 1000 ROWS IN SQL TABLE ............................
... of not knowing what the first...
--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 31, 2014 at 10:25 am

#1701687
RE: Converting sequential time records into IN and OUT times

Thanks for the feedback.
Two things, though...
1. You're the one that has to support it. Do you understand how it works?
2. I'm also still greatly concerned about 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)

March 31, 2014 at 10:17 am

#1701682
RE: The Perfect Environment

To be honest, a "perfect environment" has nothing to do with the hardware, software, revisions, or infrastructure for me. For me, a "perfect environment" is having good, knowledgeable people...
--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 31, 2014 at 10:13 am

#1701680
RE: Like operator - Query performance issue

gsaini 95591 (3/31/2014)
Partitions would be helpful.Then you could also restrict conditions in where clause
We're talking about a leading wildcard in 12 different columns. As the others have suggested, parititioning...
--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 31, 2014 at 10:07 am

#1701675
RE: Batch Delete is Slow :angry:

There is absolutely no need to use SET ROWCOUNT in SQL Server 2000. SELECT TOP works just fine except that you can't use a variable to define the TOP...
--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 30, 2014 at 8:53 pm

#1701459
RE: select sum(select sum(...))

moammermohsen (3/30/2014)
how to do this query
sum of sum
i want to Aggregate the results of a sub query which aggregate items
if i has a table with fields field_1,field_2,field_3 and my sub...
--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 30, 2014 at 8:42 pm

#1701457
RE: TEMPDB issue

poratips (3/29/2014)
Hi,
When I was looking on server drive after restarting, it is showing on folder - Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Data is 4.97 GB and when I right click on drive...
--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 29, 2014 at 9:22 pm

#1701408
RE: RecursiveHierarchyCTE

True enough. And definitely to each their own. The thing I find ironic is that, like you, I've become much more consistent in my coding over the years...
--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 29, 2014 at 9:19 pm

#1701407

Viewing 15 posts - 24,016 through 24,030 (of 59,099 total)