Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,961 through 36,975 (of 59,072 total)

RE: Increase buffer size programmatically in SQL 2000 using T-SQL

It can be done via a registry setting and, yes, that CAN be done via undocumented T-SQL sprocs but let's ask a different question, instead.... why not turn your...
--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)

September 4, 2010 at 9:39 pm

#1216615
RE: Using DateDiff to calculate days before a Birthday

kenkob (8/26/2010)
The following code will only return "No birthday(s) Pending". Any advice on correcting code would be appreciated.
Imports System
Imports System.Data
Imports System.Data.SqlServerCe
Imports System.Text
Imports System.IO
Imports System.ComponentModel
Imports System.Windows.Forms
Public Class frmKSBCards
...
--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)

September 4, 2010 at 9:30 pm

#1216612
RE: Pivot query

pandeharsh (9/4/2010)
Please check my query,only thing is that I am unable to pivot it.
I know what your next question will be but make sure that this is what you want...
--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)

September 4, 2010 at 9:19 pm

#1216611
RE: Best way to send and receive a set of records from sqlserver2005 to java

mail4sha (9/3/2010)
can u please suggest me whts the Best way to send and receive a set of records from sqlserver2005 to java......... i am all confused at wther to choose...
--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)

September 4, 2010 at 8:33 pm

#1216606
RE: Learning Oracle

What version is the government contract using, Lynn?
--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)

September 4, 2010 at 8:05 pm

#1216604
RE: Please don’t Tweet this, but…

[font="Arial Black"]From the article: [/font]
So what should we do now that we live in the new world of social media?
My answer would be... act like adults. 😉
--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)

September 4, 2010 at 7:27 pm

#1216603
RE: Learning Oracle

Lynn Pettis (8/31/2010)
Guess what, Oracle actually has CTE's, they just don't call it that in the reference manual.
True enough. And search for WITH won't do it either. They...
--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)

September 4, 2010 at 6:44 pm

#1216598
RE: Sending scheduled SQL query results via HTML e-mail using SSIS

First, yeah... I know this is a repost of an older article. The author did a nice job on the article. I've got no complaints there. 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)

September 4, 2010 at 6:29 pm

#1216596
RE: sql

Brian O'Leary (9/4/2010)
I thought I should update due to an error posted.
The assertion that the datetime data type rounds up by 3.33 ms is incorrect. After some research on this...
--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)

September 4, 2010 at 5:39 pm

#1216591
RE: Recursive select using UDF against a table?

... and let me know if that's what you wanted. I couldn't do much more because of the missing data in your tables.
--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)

September 4, 2010 at 5:32 pm

#1216590
RE: Recursive select using UDF against a table?

Ok... they pretty much screwed you by using the "Hierarchical Path" method of building hierarchies. There's a much more effecient method called "Nested Set Hierarchies" and if you do...
--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)

September 4, 2010 at 5:30 pm

#1216589
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/4/2010)
OK, I'm off to hit the chores, cut grass ... normal horse stuff.
Now wait just a bloody minute... I though that's what the horses were for!...
--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)

September 4, 2010 at 4:36 pm

#1216580
RE: database mail without cursors?

Ah... almost forgot...
There is no way that I would execute sp_send_dbmail in a trigger. If the email service goes down, new entries to the tables will either fail or...
--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)

September 4, 2010 at 4:25 pm

#1216577
RE: database mail without cursors?

Sorry this took so long... I got pretty far behind and I thought I was going to have to be twins to catch up. I hope you'll think 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)

September 4, 2010 at 4:18 pm

#1216576
RE: The Great Debate!

steve.robson 58295 (8/29/2010)
#3 is about striking the right balance of all the facets involved - not just focusing on performance for the sake of it; good enough is good enough....
--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)

September 4, 2010 at 11:43 am

#1216553

Viewing 15 posts - 36,961 through 36,975 (of 59,072 total)