Viewing 15 posts - 196 through 210 (of 1,412 total)
No, SQL Server does not work that way. What are you trying to do exactly, perhaps there is a good solution for handling it.
October 11, 2005 at 2:51 am
Well, I am using Dev Edition Sept CTP as well. So I guess we are not doing things exactly the same.
October 10, 2005 at 7:38 am
It is actually a flaw of SQL (ANSI-SQL and all flavors of it) to even put any meaning to column order.
October 10, 2005 at 6:57 am
A note regarding English Query: It no longer exists in SQL Server 2005. So I do not think you need to spend a lot of time understanding it.
October 9, 2005 at 2:02 pm
That is exactly how it does work. What version are you using?
October 9, 2005 at 6:07 am
It's impossible (or close) to get estimated time. Even if you have an estimated cost for a query you still need a lot of metrics, which will be ever-changing, that...
October 9, 2005 at 6:05 am
Is the server a member of a cluster? Tools are by default only installed on the primary node of a cluster.
Did you choose to install tools in installation (not sure...
October 7, 2005 at 3:11 am
But which edition did you download and install?
October 7, 2005 at 2:16 am
What I meant was not that you are not looking to get the best performance from a database. Naturally we choose the product and techniques that gives us the best...
October 7, 2005 at 12:03 am
Then you have probably installed SQL Server 2005 Express Edition. That is the new desktop database version and so does not come with all of the client tools, such as...
October 6, 2005 at 11:48 pm
Hungarian Notation was invented because C had no type safety, so programmers had to keep track of data types themselves.
Actually, Hungarian Notation as it is known was 'invented' by a...
October 6, 2005 at 4:18 pm
Neither you nor your friend are correct actually. The order by clause is a no-op, since the data is already sorted in that order and you are selecting all rows....
October 6, 2005 at 4:12 pm
I would say more or less no risk at all. You might of course get different query plans etc, but I assume your server's are not running the same hardware...
October 6, 2005 at 4:06 pm
Uhm, maybe not what you are looking for, but why are there a lot of databases being created without the DBA performing the action (I am assuming you are the...
October 6, 2005 at 11:45 am
Is it possible to aquire the memory? Have you tried setting min and max server memory to 2.5GB (for instance) and set workingset size to 1?
October 6, 2005 at 5:08 am
Viewing 15 posts - 196 through 210 (of 1,412 total)