Forum Replies Created
Viewing 15 posts - 36,991 through 37,005 (of 39,524 total)
-
RE: Top 5 Records
select
b.brochures
, b.pid
, h.holidays
from m_brochures b
inner join m_holidays h
on b.pid = h.BrochuresXid
where h.pid in ( select top 5
h1.pid
from m_holidays h1
where h1.BrochuresXid = b.pid
)
order by b.brochures
Steve Jones
-
RE: Database version management.
I built my own (/columnists/sjones/vcspart1.asp).
There are products from Embarkadero, CA, etc. that can help. Search the forums for version control.
Steve Jones
-
RE: Unable ton Start SQL Server Agent
Looks like a permissions error. Someone must have messed with the permissions on the server, either Filesystem or registry. Can you start it under an adminsitrator account?
Steve Jones
-
RE: URGENT! Need to recover DB after log file lost...
Stop the server and copy the .mdf file. Then try an attach, overwriting the existing database.
Steve Jones
-
RE: Updating Numerical Quantities
What type of math? Require user input? an example might help.
If it's simple math, like value * .40, then I'd
update table
set colA = ColA *.4
where pk =...
-
RE: Openquery v. Qualified Query
Update:
Nothing between the servers except a switch. They may be on separate VLans, so it's possible it is multiple switches.
However, I can run these queries together in one batch, with...
-
RE: 1 table for each combobox OR 1 for all 20 Combos?
I'd do one table as
create table(
id identity
, boxname varchar
, boxvalue varchar)
or with two tables, a lookup the the boxname and one for the values, FK to the boxname table.
Steve Jones
-
RE: This board
Used it (for the most part) as is. Modified the code a little, so we're behind in some areas from Snitz. Afraid to do the upgrade since it's pretty stable.
It...
-
RE: Messages system to users
The overhead for checks is small. Plus it's then distributed. I see a constant connection as a failure point, especially since if you do not check the link constantly, it...
-
RE: Source Safe and DB
I use SourceSafe, but script the entire db, everything, and be sure it is branched when the software code cuts. I'd keep this in a separate project with the date...
-
RE: Sort of Unique
It was a problem presented to me and it was in a narrow scope. Thanks for pointing out those bugs, I should have included those limitations in the article so...
-
RE: Performance Monitor from Web Page
In real time or later from a log?
Would be easy to display the data in a web page. Like any other query displayed on a page. Hard to give you...
-
RE: Password
With a big stick, a loud voice, and a good audit policy
Steve Jones
-
RE: removing blank spaces
Intersting. Looks like a bug. Tried this and it fails
select
len(col1)
, replace(col1, ' ', 'x')
, len(replace(col1, ' ', '-'))
, col1
from t1
From BOL, len returns the number of characters, not...
-
RE: Transfering the master database
You can look at the MS Baseline Security Tool (http://www.sqlservercentral.com/columnists/sjones/reviewmicrosoftbaselinesecurityanalyzer.asp), but it has bugs.
There isn't a good patch manager for SQL. Hopefully one will get built soon.
Steve Jones
Viewing 15 posts - 36,991 through 37,005 (of 39,524 total)