Viewing 15 posts - 916 through 930 (of 1,413 total)
What did you execute? Open a new window in Query Analyzer and execute the line below (and only that line):
SELECT @@VERSION
Anyway, if you do not know which one you are...
April 27, 2005 at 12:08 am
No, you can not change that specific timing. However, you can use SET STATISTICS TIME ON to get some detailed timing information. Look it up in Books Online. Another way...
April 27, 2005 at 12:00 am
Abraham, are you thinking of configuring SQL Server to only use some processors on a multi-proc box? If so, see affinity mask in Books Online for some information.
April 26, 2005 at 4:30 pm
Did they say anything more regarding the scenario in which multiple log files would be useful? It would be interesting to hear about it.
April 26, 2005 at 5:43 am
The log file(s) are always written sequentially. If there are more than one then only one will be used at a time. When it is filled the log will move...
April 26, 2005 at 5:06 am
Hm, just noted you did not say you were using SQL Server 2005 Beta 2. However you do say that you installed it 'a couple of weeks ago', so I...
April 26, 2005 at 3:34 am
SQL Server 2005 Beta 2 is not compatible with Visual Studio 2005 Beta 2. You should download and install the April CTP of SQL Server 2005 from MSDN Subscription or...
April 26, 2005 at 3:32 am
I think Ron is actually looking for errors (and not numbers of rows in result). However I see no reason to do so. For instance, if the table has been...
April 26, 2005 at 3:28 am
>Even though the flags variable is not stored anywhere I would still like to create an index on it.
If it is a variable, then no, you cannot create an index...
April 26, 2005 at 12:26 am
Are you sure that this needs to involve SQL Server? If the language setting is on a per-session basis then it should probably only be stored in a cookie or...
April 26, 2005 at 12:19 am
>Is there a better way?
Replace the MySQL server with a SQL Server?
No, I do not think there is a better way. I would...
April 22, 2005 at 3:43 am
I think a nice analogy to think of is how texts are translated. If you would take an English text and start translating it into another language, Swedish for example,...
April 21, 2005 at 2:16 am
Oh, I see. That's what I get for trying to tell someone how to use cursors when I never use them myself. Should have just posted the standard-anti-cursor response.
April 21, 2005 at 2:13 am
(Removed incorrect information)
Why are you using a cursor for this? You do not need a cursor here. And do you really need to be able to execute the query for...
April 21, 2005 at 12:49 am
Viewing 15 posts - 916 through 930 (of 1,413 total)