Viewing 15 posts - 20,506 through 20,520 (of 22,196 total)
Have you run a trace to capture the calls coming in to the server? Even if you identify a CPU problem, you need to figure out what's causing the problem.
April 30, 2008 at 1:29 pm
a2zwd (4/30/2008)
I am developing an application to a garment factory. I have a doubt in designing a table.
Basic tables:
Jobs, JobColors, Material, Units, Currencies ...
These tables are designed with normalization rules.
I...
April 30, 2008 at 1:14 pm
Yep. TSQL is a scripting language. As such it's sequential. To launch a seperate "thread" you have to make a completely different connection and launch a script from there.
April 30, 2008 at 1:01 pm
You can look it up in more detail in the Books Online (the SQL Server documentation), but Text is a BLOB or Binary Large Object data type. It stores data,...
April 30, 2008 at 1:00 pm
You can switch over to the decimal data type and you shouldn't lose any of your data. You'll have to write a script that migrates it over course, but no...
April 30, 2008 at 12:53 pm
You can get that specific count for your manager one of two ways. Safely:
SELECT COUNT(*)
FROM MyTable
WHERE MyColumn = 'OldValue'
Or not so safe:
BEGIN TRAN
UPDATE MyTable
SET MyColumn = 'NewValue'
WHERE MyColumn = 'OldValue'
ROLLBACK...
April 30, 2008 at 10:58 am
Probably. I couldn't find good documentation on the detail of this, but my understanding is, the batch or rpc complete events include all the server side processing, beginning to end....
April 30, 2008 at 9:34 am
Jason Selburg (4/30/2008)
Now that's funny! I used to listen to fish farts on the USS Silversides (SSN 679) back in '89.
I wonder how many other squids are on here....
See....
April 30, 2008 at 9:28 am
Good suggestions and I'm happy to be wrong about the query hint.
April 30, 2008 at 6:55 am
Are the updates and the reads against the same data? Before you do something drastic (the very next post is probably going to suggest using a query hint on the...
April 30, 2008 at 6:24 am
Lots better.
If nothing else, instead of dynamic queries, use a table valued function to pivot your comma delimited list into a table and then join against it. It's not always...
April 30, 2008 at 6:18 am
Use Modulo 4 and Modulo 6 to limit the values to quarterly & every six months. Of course, you can only use June & December for the six month breaks.
April 30, 2008 at 6:16 am
Parameter sniffing?
Or, if we've got a procedure that consists of views, calling views, calling views... bad execution plans?
Look at the execution plan when it performs badly and when it...
April 30, 2008 at 6:15 am
svhanda (4/30/2008)
I had problem in updating a table ...
My query is suppose there is table like
EMP_ID Comp_ID
100 ...
April 30, 2008 at 6:06 am
There is no way to "link" databases in SQL Server so that you can have cross-database referential integrity. Period. End of Story.
However, you could write a trigger that will validate...
April 30, 2008 at 6:02 am
Viewing 15 posts - 20,506 through 20,520 (of 22,196 total)