Viewing 14 posts - 211 through 224 (of 224 total)
There are joins to look up the values "Yes/No" and "Male/Female"? OK...
Why not try to eliminate those? It may not help much, but you said there was a lot...
October 25, 2006 at 8:35 am
A certification should be made very clear on any sort of resume. And the term MCDBA is already outdated!! It doesn't exist for SQL Server 2005. The new terms are...
October 23, 2006 at 8:27 am
No se exactament que seria el problema. Busque un propiedad (property) de timeout en la aplicacion.
Anyone care to take a stab at it in English? I'll just paraphrase the...
October 11, 2006 at 1:47 pm
The best idea is to add the updates to the insert statement.
INSERT INTO Xpophd
SELECT colA, colB, colC, current_timestamp, system_user
FROM deleted
Fix the column list so that it contains all...
October 10, 2006 at 7:33 am
Adding to my recent post, there is no Transact-SQL statement because it's a registry setting!
The Script button in Management Studio appears to produce the wrong registry setting, because that's not...
October 6, 2006 at 8:52 am
Your connection string looks good. I have SQL Express on my box, but I don't use it. So I tried to set up a connection similar to yours. I created...
October 6, 2006 at 8:43 am
Consider using a user-defined function here. Inside the user-defined function, you could use hard-coded values or a table or any other algorithm you want. This allows your method of determining...
October 5, 2006 at 9:02 am
Thanks for the replies. The ROWCOUNT setting works.
I was a DBA for SQL6.5, left the field, and recently have been learning SQL2005. But I skipped 7 and 2000!! So I...
October 3, 2006 at 3:24 pm
GRANT ALTER SCHEMA :: dbo TO developerUserName
This grants the developer permission to create, alter or drop any database ojbect in the dbo schema. I don't think there's anything less restrictive...
October 3, 2006 at 9:02 am
This is a security error related to digital signatures. It doesn't have that much to do with Full Text, except that Full Text doesn't run in the same process as...
July 27, 2006 at 11:28 am
If you are going to try for MCTS in SQL Server 2005, I recommend the training kit book (Microsoft SQL Server 2005 Implementation and Maintenance Training Kit). It is very...
July 27, 2006 at 11:18 am
If you already had SQL Server Express installed (for example, with Visual Studio 2005), it may have prevented installation of the full set of client tools. This happened to me when...
July 11, 2006 at 9:33 am
I think the real distinction is not CS degree or not, but degree or not. Not having a degree will stop many companies from considering a person, regardless of experience...
June 29, 2006 at 9:37 am
If the latest query you posted is accurate (the real query is always more useful--you can inadvertantly fix the problem while "cleaning up" for posting), I think I see the...
June 29, 2006 at 9:04 am
Viewing 14 posts - 211 through 224 (of 224 total)