Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,531 through 25,545 (of 59,099 total)

RE: longtext

I don't know if it's appropriate here or not but I find that a lot of people use OPENROWSET as a defacto standard for a lot of things where something...
--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)

October 30, 2013 at 3:54 pm

#1662871
RE: Using ::fn_dblog() to find who deleted the rows in a table.

arnipetursson (12/28/2012)
I am aware of that.
However you can deduce who is doing what based on the entries in the default trace.
How? How can you deduce who did a simple...
--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)

October 30, 2013 at 3:51 pm

#1662869
RE: How to Change the default date format in sqlserver 2005

Ron Kunce (10/30/2013)
Along this line about the Default datetime value display (in SQL Server 2005) I do not understand why if I declare a variable as a datetime type and...
--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)

October 30, 2013 at 3:42 pm

#1662865
RE: Are the posted questions getting worse?

WayneS (10/30/2013)
SQLRNNR (10/30/2013)
Sean Lange (10/30/2013)
GilaMonster (10/30/2013)
I remember seeing a CV where someone had rated himself 10/10 on 4 versions of Windows (XP, 2000, 98, NT4), two versions of SQL 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)

October 30, 2013 at 11:48 am

#1662816
RE: How can I handle the following query ??

ahmedhussein874 (10/30/2013)
Thanks a lot Luis .. Can I handle it without functions ?? is there any other alternative way ??
Why do you want to do it without the use of...
--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)

October 30, 2013 at 8:56 am

#1662750
RE: How about a Stairway to CLR series

First, let me state flatout that I'm NOT an anti-CLR zealot. I'm also NOT an anti-Cursor zealot. They both have their places and their uses.
Much like the use...
--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)

October 30, 2013 at 8:25 am

#1662733
RE: Disk Is Cheap! ORLY?

aalcala (10/29/2013)
Jeff Moden (10/29/2013)
aalcala (10/29/2013)
... we have more than 10,000 source files being maintained by a team of 5 developers.
I'm just curious. what kind of files are those and...
--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)

October 30, 2013 at 7:59 am

#1662724
RE: Performance of the SQL MERGE vs. INSERT/UPDATE

King Conch (10/29/2013)
...but does anyone have an opinion on using the Binary_CheckSum?
Yes. I'd advise extreme caution. Run the following and see why.
SELECT BINARY_CHECKSUM(CAST( 2 AS BIGINT))
...
--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)

October 29, 2013 at 6:54 pm

#1662588
RE: Are the posted questions getting worse?

Chad Crawford (10/29/2013)
We use the scale of 1-10 to help give us an idea of how tough to start the interview questions, but we usually give the scaling factor...
--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)

October 29, 2013 at 6:09 pm

#1662582
RE: Disk Is Cheap! ORLY?

aalcala (10/29/2013)
... we have more than 10,000 source files being maintained by a team of 5 developers.
I'm just curious. what kind of files are those and what format are...
--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)

October 29, 2013 at 11:17 am

#1662466
RE: Fill up position numbers

Steve Goram (10/29/2013)
This is my file (fixed lengths):
item 1 tire
color ...
--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)

October 29, 2013 at 10:58 am

#1662457
RE: Limiting the amount of code in an HTML rendered report

brickpack (10/29/2013)
Thanks Jeff... I also use FOR XML PATH for some of my smaller reports. 🙂 I was was hoping there was some way to turn the HTML...
--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)

October 29, 2013 at 10:48 am

#1662455
RE: Cascade parameters

OPTION 3:
Do it all in T-SQL (control SP that calls the other 2?) and just present the final result set to Reporting Services.
--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)

October 29, 2013 at 8:55 am

#1662395
RE: Limiting the amount of code in an HTML rendered report

Yes. That's why I don't use SSRS for most things. The HTML bloat is ridiculous.
If you're not including any graphs in the email, lookup sp_senddbmail in Books Online...
--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)

October 29, 2013 at 8:52 am

#1662393
RE: Cluster Re-Index

One option to consider when rebuilding indexes for defragmentation purposes is the WITH DROP_EXISTING option. You can read more about it at the following URL (2005 version)...
http://technet.microsoft.com/en-us/library/ms188783(v=sql.90).aspx
Once that page...
--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)

October 28, 2013 at 7:23 pm

#1662205

Viewing 15 posts - 25,531 through 25,545 (of 59,099 total)