Viewing 15 posts - 256 through 270 (of 321 total)
salibindla_m (4/1/2008)
I am trying to move objects,Sps,views,Udfs from one database to another meaning cleaning the junk.is there any script that I could find Tables,Sps.views udf's dependencies and than recreate the...
April 3, 2008 at 10:35 am
This got me thinking... I haven't seen any posts from Phil for a while.
April 1, 2008 at 9:41 am
Michael Valentine Jones (3/26/2008)
The data transfer rate of a FedEx package is very high.
You just made my day! What a great line.
March 28, 2008 at 9:59 am
Another option would be to setup a Server 2003 on a Virtual PC. they usually run better from an external drive, but since you have 2 HDs on your laptop,...
March 28, 2008 at 9:50 am
As a developer, I know how easily the mind's scope can be narrowed to just the single application that I'm working on. That still isn't an excuse to produce an...
March 26, 2008 at 9:11 am
Lisa Slater Nicholls (3/16/2008)
However, when one post examples using Oracle or SQL 2005 you often get a question about "how to do this in SQL 2000". I usually...
March 17, 2008 at 8:00 am
Keep in mind that if just 1 row meets your criteria, you will be undoing the entire update.
March 14, 2008 at 8:08 am
As a DBA you will be better off with a single point of reference for histories, errors, restores, etc.
Unless you are the person responsible for ALL backups, use native backup....
March 14, 2008 at 7:55 am
CREATE TABLE #PriceCompare (
ITEMNMBR varchar(31),
ITEMDESC varchar(101),
DOCDATE datetime,
UNITCOST numeric(19, 5),
rownum int identity
)
INSERT INTO #PriceCompare
SELECT
RTRIM(PH.ITEMNMBR) [ITEMNMBR],
RTRIM(i.ITEMDESC) [ITEMDESC],
ph.DOCDATE,
ph.UNITCOST
FROM IV00101 i
INNER JOIN IV30300 ph
ON i.ITEMNMBR = ph.ITEMNMBR
ORDER BY...
March 13, 2008 at 10:54 am
If there is common data used by multiple databases of a single application, it is unfortunate that the application designers didn't think to use an Application Master database for housing...
March 13, 2008 at 9:20 am
jordonpilling (3/13/2008)
a very nice article indeed, however i recently had the same issue on SQL Server 8.0, Is their a related atricle/method for SQL 8?
You should be able to do...
March 13, 2008 at 8:42 am
Karma (3/6/2008)
Interesting topic 🙂
Does anyone else think it's slightly obtuse to spend time creating naming standards for tables and then alias them in code with something so meaning less as...
March 6, 2008 at 10:45 am
paulhunter (3/5/2008)
March 6, 2008 at 6:31 am
paulhunter (3/5/2008)
xmlish short hand for stating it's an opinion. Or, was the "huh?" that you didn't understand the why and where of that comment?
I'm afraid I didn't understand the...
March 5, 2008 at 6:08 pm
Viewing 15 posts - 256 through 270 (of 321 total)