Hi, Can someone point me to a site with an article ofone or two that explains how to read the result of an execution plan? If I have for example a...
When debugging stored procs, what should be the format for the value of a date parameter? I've tried the following but it's not accepting the value:...
Does bulk copy activate a trigger? Kindly explain if it does. Thanks.
Can someone give me an example of an xml mapping schema? I found an article talking about loading an xml into sql using bulk insert and then I...
I think I have asked this question before but I could not find the thread so I can post additional questions there. So please forgive me if I have to...
Is it possiblt to span a DB to multiple machines? Can you give some good URLs explaining this in concept and if possible how to do it? Or can...
Hi! What would be the best approach for this: --Table X Code PriceType1 Price1 PriceType2 Price2 PriceType3 Price3 --Table Y CodeY CodeX PriceType...
Is there any "big" difference on the performance of an sproc between one with multiple if-statments and one with none. Suppose I have this: --sproc1...
Hi! I have a huge logfile and I wanted to know how can I make it smaller. I tried truncating it and shrinking it but the file is still huge. So what...
What is the fastest way to do this:<br />I have a student table, course table and enrolled courses<pre id="code"><font face="courier" size="2"...
What are the possible reasons that the format of a date column is being changed to another format. The date column should the format like dd/mm/yy,...
I created a SVF using VB.Net and I had my function declared like this:<br /><br...
Does OBJECT_ID change when, say, you alter a table or do something else with the table. From how SQL generate a test script when creating objects...
What would be the best way or the best approach/design for dynamic query? Say in my front-end application the user has many options that enable him...
If I just have a SELECT statement, is it better to have it in a stored proc or in a view? I know that one of VIEW's advantages is that you can apply...
There is always a disk activity when my sqlserver is running and my pc is slowing down, drastically. This happens even when the server is stopped....
in sql 2000 i could do this: SELECT * FROM MyTable WHERE Fld1 > 8 AND Fld2 = 'test' (where Fld1 is a varchar) and it returns no error wen i ran...
I've shrunk my database and my log file is still too large. My mdf is just around 150MB but my ldf is over 2G.
Separate names with a comma.
