Forum Replies Created
Viewing 15 posts - 376 through 390 (of 921 total)
-
RE: IndexProperty and create Index
Apply the locking override properties with sp_indexoption.
The creation options DROP_EXISTING and SORT_IN_TEMPDB are only relevant during creation, so they're not stored anywhere other than if you save the...
-
RE: Backup file Security if it is stolen
Use the PASSWORD option when backing up.
--Jonathan
-
RE: Table and Column layout vs. Page allocation
As your column widths cannot sum to more than 8060 bytes, there's something wrong with your examples. A row's size cannot exceed one page (BLOBs, of course, being a...
-
RE: Query generates different exec plan!
Sounds like the statistics differ between the two servers. If the "slow" server has stale (or missing) statistics, it could easily choose a sub-optimal plan methodology.
--Jonathan
-
RE: Backup a currently running database
quote:
Using third-party backup tools, can require you to put the database in SINGLE user mode and kick users out.December 5, 2003 at 10:32 am
-
RE: Having Trouble with EXISTS
You need to correlate the existence subquery, e.g.
...
AND EXISTS (SELECT *
FROM A04Code
... -
RE: Remove alpha characters
quote:
For long strings with more than a small percentage of characters that must be stripped, the overhead of the PATINDEX and STUFF... -
RE: default date format
quote:
Quick brainteaser for our beginning DBA's: what's the quickest method to strip out the time from a DATETIME field (returning only... -
RE: Update Row with Combination of Values
This should be easy to do. It's essentially just three statements.
UPDATE TimeOff
SET Code = 50
WHERE Code = 45
AND NOT EXISTS
(SELECT *
FROM TimeOff t
WHERE... -
RE: Happy anniversary
Congrats, Frank! Have a "real" Budweiser on me!
quote:
Hey, I expanded my vocabulary today with two new ones.That's too much, I need...
-
RE: How to add a carriage return
If I understand your need, this is difficult in T-SQL but easy in any programmable front-end. If you can't manage this on the front-end, then perhaps just using some...
-
RE: Dynamically determining a Top n for Top keyword
quote:
Forget it, I had a typo when searching my online dictionary
Frank
Just...
-
RE: Alternative to cursor
quote:
Jonathan,I believe yours will not select anything or the wrong results.
Correction, it will if cust is the same for each account.
-
RE: Dynamically determining a Top n for Top keyword
quote:
Thanks a lot Jonathan ! The script helps me to solve the problem. But if I want use the top 10 drug... -
RE: Alternative to cursor
SELECT c.Class, c.Account, c.Cust, c.Doc_Type
FROM Documents c LEFT JOIN Documents o ON o.Account = c.Account AND o.Doc_Type IN ('ORIG1','ORIG2')
WHERE c.Doc_Type IN ('COPY1','COPY2')
AND o.Account IS NULL--Jonathan
Viewing 15 posts - 376 through 390 (of 921 total)