Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,996 through 41,010 (of 59,102 total)

RE: Sql date range Issue

Keep it simple...
WHERE Time_Date between ISNULL(@startdate,0) and @enddate
--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)

November 25, 2009 at 3:10 pm

#1084382
RE: Reclaiming unused space in a table

The amount of freespace in the table is pretty much consistent with the fact that the clustered index has a FILL FACTOR of 80. The only way to make...
--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)

November 25, 2009 at 3:08 pm

#1084379
RE: Verboten keywords to assure SELECT only commands

dba_pkashyap (11/25/2009)
How about DDL triggers at database level!!!
I'm liking that but can't you just set the users up with "data reader" only?
--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)

November 25, 2009 at 3:00 pm

#1084377
RE: Rant of the Day

I agree with what Gail said and for the very same reasoning. However, I use TINYINT for things like this because it doesn't require any logic at all to...
--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)

November 25, 2009 at 2:17 pm

#1084352
RE: Newbie Frustration - SQL Server 2000

Bru Medishetty (11/25/2009)
Use having clause at the end.
having [Purchase_%] > 50
I did not try on your query since I don't have the table / column details.
Bru... if you copy 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)

November 25, 2009 at 2:04 pm

#1084348
RE: Newbie Frustration - SQL Server 2000

CirquedeSQLeil (11/25/2009)
Bru hinted at a very important thing here at SSC. We can offer suggestions for your query, but it is very difficult to provide accurate solutions without having...
--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)

November 25, 2009 at 2:02 pm

#1084347
RE: Return most recent of a sub group of records

Ron-279530 (11/25/2009)
THanks for your feedback
Heh... I'm going to assume that you still don't have an answer to your original question but, first...
I notice from your post count that you're still...
--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)

November 25, 2009 at 2:00 pm

#1084345
RE: updating data

... and it didn't take you long, either. 🙂
Just a couple of concerns for your code and data....
1. Town names aren't unique and any given town name could appear...
--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)

November 25, 2009 at 1:28 pm

#1084321
RE: Simple and fast front end for user to execute a stored procedure after keying a variable

You could always do this in a spreadsheet with a pushbutton macro to read a cell (or an input message) and return the results to the spreadsheet.
--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)

November 25, 2009 at 12:58 pm

#1084298
RE: Update HELP

john scott miller (11/25/2009)
Did you actually try that, John? It returns exactly the same phone number for all rows.
--Jeff Moden
-------------------------------------------------------------------------------------
No i did not and that is why i am...
--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)

November 25, 2009 at 12:54 pm

#1084295
RE: A welcome message to all Forum Newbies

Heh... wow... people jumped on that post like white on rice... there' weren't any posts between the original and mine when I first looked at the post. Folks even...
--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)

November 25, 2009 at 12:40 pm

#1084285
RE: A welcome message to all Forum Newbies

It's a great idea and it's been suggested many times. But, just like a EULA, how do you guarantee that a newbie will actually read it never mind follow...
--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)

November 25, 2009 at 12:38 pm

#1084284
RE: tempdb full

Heh... wait a minute, now... how big are the MDF and LDF files for TempDB? How much freespace do the other DB's have? Have you verified that TempDB...
--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)

November 25, 2009 at 12:35 pm

#1084280
RE: tempdb - understanding unallocated space

repent_kog_is_near (11/24/2009)
I am with you in principle. I am asking what is technically going on inside, that may block a shrink, even when there is enough unused space.
Ah... got you....
--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)

November 25, 2009 at 12:31 pm

#1084277
RE: Creating simple dynamic sql

lonesome (11/23/2009)
Thanks every body I solved my problem. Here is the solution.
I am really grateful to every body for help and time
ALTER PROCEDURE [dbo].[AdminSelectMovie]
@Movies VARCHAR(20), --For where clause. 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)

November 25, 2009 at 12:06 pm

#1084260

Viewing 15 posts - 40,996 through 41,010 (of 59,102 total)