Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,101 through 50,115 (of 59,091 total)

RE: how can i make the database unusable to detach it from my application

I'm thinking that your connection string had better be connecting you to some database other than the one you're detaching.
--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)

June 12, 2008 at 8:20 am

#827891
RE: Working With Cubes

These are some fairly broad questions that would probably be best answered by looking up things like "working with cubes in SQL Server" or "using olap" or somesuch in Books...
--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)

June 12, 2008 at 8:14 am

#827885
RE: working online

Might have to setup something like a web service to run on an intra net... lot's of folks do such a thing... Talk to anyone who writes ASP.Net 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)

June 12, 2008 at 8:04 am

#827876
RE: Table locked after t-sql runs

There are very few reasons why this may happen...
--Uncommitted transaction
Do a transaction count at the end of the proc to find out. Might take a bit to find if...
--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)

June 12, 2008 at 8:00 am

#827870
RE: Making it pivot

SQL Server 2005 allows you to write PIVOT queries. Lookup the keyword PIVOT in Books Online. Books Online comes free with SQL Server and is the "help" system...
--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)

June 12, 2008 at 7:34 am

#827845
RE: Database Growth Settings

Not likely the database did it... either a human or some other program did it. Finding out what changed it will take some doing, though.
Should never grow by percent,...
--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)

June 12, 2008 at 7:32 am

#827843
RE: Remove Locking from particular row

One of the cylinders on my car is misfiring... I can't understand why the mechanic blew me off when I told him he couldn't look under the hood because I...
--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)

June 12, 2008 at 7:29 am

#827837
RE: Algorithm For Email

I'd say that's a pretty tall order unless you have a particular domain in mind that want's particular formatting rules. Then, you could use LIKE to build a...
--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)

June 12, 2008 at 7:23 am

#827828
RE: Dividing count(*) by DateDiff always equals 1

Here's a "cheater" method...
count(*)*1.0/(DATEDIFF(s, MIN(scan_datetime), MAX(scan_datetime))) as ItemsPerSecond
--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)

June 12, 2008 at 7:12 am

#827814
RE: Get date of last Sunday of every month

Ok... now that everyone has figured stuff out... how 'bout everyone post their solutions? 😉
--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)

June 12, 2008 at 7:07 am

#827810
RE: What do you do with a new SQL Server?

I found it... them, really.
http://www.sqlmag.com/Articles/ArticleID/19851/19851/pg/2/2.html?Ad=1
http://www.sqlmag.com/Article/ArticleID/20242/sql_server_20242.html
I'm not a "member" of that particular site so I can't see the whole article. What I glean from the two articles is...
--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)

June 12, 2008 at 6:54 am

#827800
RE: What do you do with a new SQL Server?

AndyD (6/12/2008)
Jeff Moden (6/12/2008)
I remember seeing an article on the difference between 0% and 100% fill factors... Dunno if I can find it, again, but I'll look...
I was only regurgitating...
--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)

June 12, 2008 at 6:43 am

#827795
RE: What do you do with a new SQL Server?

AndyD (6/12/2008)
Yes, I agree, good concise advice.
Just one quick question - you mention the Fill Factor defaults to 100% in 2005, whereas it was 90% in 2000. [To be precise,...
--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)

June 12, 2008 at 6:26 am

#827785
RE: What do you do with a new SQL Server?

Nice, clear, well written article with good advice. Thanks!
--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)

June 11, 2008 at 10:11 pm

#827638
RE: SQL Defrag

Dominique DUCHEMIN (6/11/2008)
To defrag is it always a manual process for safety reason or other or could we automate the process?
Sure... create a scheduled job... you can use 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)

June 11, 2008 at 9:05 pm

#827627

Viewing 15 posts - 50,101 through 50,115 (of 59,091 total)