Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,856 through 48,870 (of 59,099 total)

RE: Need Help in SQL 2005 performance Tuning

If it's been 2 years since the move and everything else is moving smartly, then it could be that the code for the reports just wasn't written is a scalable...
--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)

August 10, 2008 at 5:49 pm

#855837
RE: Store word doc/image on sql server

I believe the question is how to load the Word file into the VARCHAR(MAX) element.
And, yes, I agree... it's probably better to store the name of the file in 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)

August 10, 2008 at 5:37 pm

#855836
RE: Bill Baker

bakerbill (8/9/2008)
Leaving MS was not Bill's decision to make. He was given the scope and resources to succeed, but he could not deliver. His mistakes eventually became too costly 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)

August 10, 2008 at 5:34 pm

#855835
RE: Move one databse from one server to other one, and renamed it

Waseem Jaleel (7/21/2008)
once u complete attach/rename, u need to fix the users for the db, as there will be an SID mismatch since you have moved it to 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)

August 10, 2008 at 5:28 pm

#855833
RE: CTE / VIEW

A CTE is nothing more than a "derived table" just like a subquery in a FROM clause would be. The big differences between itself and a "derived table" 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)

August 10, 2008 at 5:26 pm

#855832
RE: Find distinct special characters in column

Heh... spot on, actually. Sergiy is absolutely correct.
--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)

August 10, 2008 at 3:51 pm

#855807
RE: joining the tables

So change the update code to insert code and change the join to be a WHERE NOT EXISTS or other exclusionary join.
--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)

August 10, 2008 at 2:22 pm

#855800
RE: Importing / Parsing text file with different formatted rows?

I do this same thing with a lot of mixed record files... they're usually fixed width instead of delimited, though. Anyway, I bring the whole file in as 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)

August 10, 2008 at 2:13 pm

#855799
RE: Get Record Count for each table in a database.

... and, with SQL Server 2000, we end up with this...
DBCC UPDATEUSAGE (0)
SELECT so.Name AS TableName,
si.Rows AS [Rows]
...
--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)

August 10, 2008 at 1:48 pm

#855796
RE: Get Record Count for each table in a database.

So... hedging a bet against BOL and changing the code to something a bit more conventional, we end up with this...
DBCC UPDATEUSAGE (0)
SELECT so.Name AS TableName,
...
--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)

August 10, 2008 at 1:43 pm

#855793
RE: Recommended reading?

I've found that most of the books are simply a slightly longer, more expensive regurgitation of Books Online. Most of the books I've read don't explain things like 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)

August 10, 2008 at 11:40 am

#855784
RE: Trigger Not Executed even if record is inserted or Updated

It can't happen unless the trigger has code in it telling it to ignore the inserts from WinCC. Recommend you post the trigger code.
--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)

August 10, 2008 at 11:10 am

#855777
RE: Get Record Count for each table in a database.

rbarryyoung (8/10/2008)
Gimme time to eat lunch, Jeff! 😛 🙂
Heh... hey! I need to know... does brother Darth have to take off the Chevy look-alike to eat?
--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)

August 10, 2008 at 11:07 am

#855776
RE: Get Record Count for each table in a database.

Jeffrey Williams (8/10/2008)
For SQL Server 2005 and greater - there is no need to cursor at all. Just use the DMV sys.dm_db_partition_stats as in the following:
Select object_schema_name(object_id) As...
--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)

August 10, 2008 at 10:56 am

#855774
RE: Importing / Parsing text file with different formatted rows?

Also, have 0x100 as the row identifier for both the teacher and the test page does not seem logical... are you sure about that?
--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)

August 10, 2008 at 10:48 am

#855772

Viewing 15 posts - 48,856 through 48,870 (of 59,099 total)