Viewing 15 posts - 1 through 15 (of 22 total)
Also - More specific Certs like Cisco has are great for identifying specialties but it will also create a perceived need to have multiple certs. Plus the people doing the...
April 20, 2005 at 11:46 am
One aspect of the problem with certifications is the perception of these certs by CFO's and others that do the hiring of IT people. I personally beleive that the...
April 20, 2005 at 11:43 am
Thanks John that helps.
So sp_prepexec takes a command string as input, and generates an execution plan so that it can be quickly executed later??
December 29, 2004 at 8:23 am
I think for some reason SQL requires a different thought pattern than standard programming. Much of the reading I have done instructs you to think of SQL as just another...
November 30, 2004 at 1:51 pm
Thanks,
I knew I was overlooking something simple.
November 30, 2004 at 1:39 pm
From the MS Access find duplicates query wizard...
SELECT First(dbo.tablename.key_column) AS [DUPE_ID], Count(dbo.tablename.key_column) AS NumberOfDups
FROM dbo.table
GROUP BY dbo.tablename.key_column
HAVING (((Count(dbo.tablename.key_column))>1));
November 24, 2004 at 3:22 pm
Found the problem:
http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;296769
I added
SET ANSI_NULLS ON
GO
To the top of the CREATE PROCEDURE statement and all is well.
Thanks for your reply.
November 24, 2004 at 2:45 pm
In QA I Ran This Successfully:
SELECT [DESCRIPTION]
FROM LINK_SERVER.VMFG.dbo.PART
WHERE ([ID] = 'CFR26141585')
However, when I try to put...
November 24, 2004 at 2:33 pm
Not a solution but some input.
I have a low use SQL 2K install on 2003 Server std edition. have not seen your problem but have seen the SQL Service...
November 17, 2004 at 10:38 am
Should I run an update query on the sysindexes table to set the OrigFillFactor to 0? As I said above for some reason this is set as 25 in the...
November 3, 2004 at 10:47 am
The log file is only showing as 50MB. What is your take on the results of sp_spaceused null, true showing 1,963,280 KB as index space?
November 3, 2004 at 9:59 am
ran sp_spaceused null, true:
~ Old Normal Sized DB Results ~
database_name ...
November 3, 2004 at 8:50 am
I ran this:
sp_msforeachtable 'dbcc dbreindex(''?'')'
then:
DBCC SHRINKFILE (1)
Then:
DBCC SHRINKDATABASE (PLAY2,1)
The SHRINKDATABASE command only took 1 second to complete.(?)
In Enterprise Manager I see:
Data Fles Tab shows 4603MB Space allocated
Transaction log 50MB Space...
November 2, 2004 at 4:52 pm
SQL SERVER 2000 SP3a on Win2000 Server SP4
The DB has 1 datafile and I ran DBCC SHRINKFILE (1)
This only brings the datfile down to 4.8GB. It was at ~ 2GB...
November 2, 2004 at 8:55 am
Viewing 15 posts - 1 through 15 (of 22 total)