Jeff Moden

Forum Replies Created

Viewing 15 posts - 31,156 through 31,170 (of 59,101 total)

RE: Mulitple Saarch Criteria using ONE Column

Sankar,
In the future, help us help you. Please post your data as I've done below. See the first link in my signature line below for more details.
CREATE...
--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)

February 13, 2012 at 10:15 pm

#1446630
RE: Best way to eliminate duplicate sets of data

SQL Kiwi (2/13/2012)
Jeff Moden (2/13/2012)
Nicely done, Paul. Will that preserve keys, constraints, and indexes? And, yes, I realize the TRUNCATE won't work if FK's are present.
One of 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)

February 13, 2012 at 10:05 pm

#1446629
RE: data not getting Loaded from csv file to sql server 2008 r2 table (Enterprise edition)

The error is pretty much self explanatory. You have a "field" in the data (probably the 76th field) that's too big for the table. Temporarily change the 76th...
--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)

February 13, 2012 at 9:52 pm

#1446626
RE: granting execute privilege on all stored procs in a database to a user

SQLKnowItAll (2/13/2012)
USE databaseName
GRANT EXEC ON SCHEMA::dbo TO userName
That should do the trick, assuming the schema for these objects is dbo! Else, replace dbo with the schema you need.
That could be...
--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)

February 13, 2012 at 9:44 pm

#1446623
RE: DBCC REINDEX on table with 970GB data and 10GB index with 5 billions rows of count

Maramor (2/13/2012)
I was curious what approach would be used to fix this particular situation.
If you have the Enterprise edition, partition the large tables by "row date" and "align the indexes"...
--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)

February 13, 2012 at 9:42 pm

#1446621
RE: Need advice -- Backups

If your backup files are much larger than the MDF/LDF files, then you may have multiple backups in the same file. I look at that as putting a lot...
--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)

February 13, 2012 at 9:25 pm

#1446617
RE: Optimize speed of maintenance tasks

Since you don't have the Enterprise Edition, you can't do table partitioning. However, you can still build Partitioned Views where you can separate the older, mostly static data from...
--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)

February 13, 2012 at 9:07 pm

#1446616
RE: Drive Cleanup Script

ahthomas (2/13/2012)
That's not really what I am looking for but thanks. We enforce disk quotas for the developers so we don't want a ton of old crap laying around in...
--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)

February 13, 2012 at 9:00 pm

#1446614
RE: Moving database

That won't actually switch the database from SQL Server 2000 to 2008. Your server may be 2008 but your databases will still be SQL Server 2000. Don't just...
--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)

February 13, 2012 at 8:55 pm

#1446612
RE: Best way to eliminate duplicate sets of data

Nicely done, Paul. Will that preserve keys, constraints, and indexes? And, yes, I realize the TRUNCATE won't work if FK's are present.
--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)

February 13, 2012 at 8:35 pm

#1446610
RE: How to query based on a specific time range...

P.S. I won't explain it now because you won't believe me but when you eventually get burned by using BETWEEN with datetime datatypes, remember this post and that I'm...
--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)

February 13, 2012 at 8:29 pm

#1446607
RE: t-sql

In the future, please post your data using the methods found in the article at the first link in my signature line below. 😉
Also, your example data has two "col6"...
--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)

February 13, 2012 at 8:22 pm

#1446606
RE: Best way to eliminate duplicate sets of data

Now that the deletion of duplicates has been resolved, you might want to take a look at the structure of your table and figure out what would make a good...
--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)

February 13, 2012 at 7:32 pm

#1446602
RE: How to query based on a specific time range...

Vincy-856784 (2/13/2012)
I tried first but gave me conversion error. But now, it works without converting to string. Thank you Anthony one more time. You saved my day!...
--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)

February 13, 2012 at 7:27 pm

#1446601
RE: 30-day demo period

Stevie T (2/13/2012)
wow. thank you very much, that's exactly what i want. implemented and wrapped. nice job -thank you.
Will the customer have any logins with "SA" privs....
--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)

February 13, 2012 at 7:19 pm

#1446599

Viewing 15 posts - 31,156 through 31,170 (of 59,101 total)