Viewing 15 posts - 2,521 through 2,535 (of 3,232 total)
What error are you getting with OSQL? Can you post the error syntax? Have you tried the -E switch with OSQL?
For example, >OSQL -S <servername> -E -Q "select *...
November 30, 2006 at 9:37 am
I agree, this sounds like a cluster problem not SQL Server. You said: "Spent alot of money to do this and after 3 attampts to cluster"; does this mean that...
November 21, 2006 at 4:02 pm
Claude,
There are a couple of things going on here. First, you want to know if you can prevent your SELECT from blocking your UPDATE. The answer is yes, but...
November 21, 2006 at 3:40 pm
Well, first of all, you'll need (or want) a unique index on Customer No and Site ID in your thrid table. You could then either have the INSERT trigger determine the...
November 21, 2006 at 2:29 pm
You're right, a table can have millions of rows. I've never had problems running QA using Microsoft's Remote Desktop Connection (formerly terminal services). If this starts happening again, I would...
November 20, 2006 at 3:22 pm
Well, there are a few things to consider here. As SQL Oracle stated, using filegroups can help you improve performance. This is done by spreading...
November 20, 2006 at 3:04 pm
Remi, I did not read you post prior to submitting mine. You are correct. SysDepends may not be 100% accurate.
November 20, 2006 at 1:45 pm
That should work too. I also should have used DISTINCT. Your solution may return stored procedure names that do not actually reference the table. Let's say that you have the...
November 20, 2006 at 1:37 pm
SELECT SO.Name
FROM SysDepends SD
INNER JOIN SysObjects SO
ON SD.ID = SO.ID
INNER JOIN SysObjects SO2
ON SD.DepID = SO2.ID
WHERE SO2.Name = 'XYZ' AND SO.xtype = 'P'
November 20, 2006 at 1:06 pm
November 20, 2006 at 12:34 pm
I see a couple of things here. First, did you apply the AWE hot fix for SP4? If not, there is a bug with AWE in SP4 that Microsoft has...
November 20, 2006 at 12:19 pm
So instead of merging filegroups, you need to merge datafiles within a filegroup? If so, make sure your target datafile is set to autogrow, then run a DBCC SHRINKFILE <FileName...
November 20, 2006 at 8:48 am
Gabola71, what does the COALESCE end up doing to your query plan?
Ken and Sergiy,
Ken's theory is interesting. I too have seen 3rd party optimizing tools (Quest Cenral) where COALESCE was...
November 17, 2006 at 1:08 pm
Personaly, I would put this into a stored procedure. What are you going to do with the comma delimited list once it is returned? The reason I ask is that...
November 17, 2006 at 10:10 am
If I am reading you correctly, you want to always grab the previous fiscal year. This means that your month and days will always be the same because your fiscal year...
November 17, 2006 at 9:59 am
Viewing 15 posts - 2,521 through 2,535 (of 3,232 total)