Forum Replies Created
Viewing 15 posts - 1,351 through 1,365 (of 1,412 total)
-
RE: Using CASE to make a dynamic Order By
Antares, will that work? The first part I mean, the ORDER BY clause. I thought you needed to have all sort columns of the same data type, that's why I...
-
RE: Using CASE to make a dynamic Order By
You can also change it to this:
ORDER BY CASE WHEN @SortBy = 'CompetitorID' THEN CompetitorID END
, CASE WHEN @SortBy = 'Name' THEN LastName END
, CASE WHEN @SortBy = 'State' THEN...
-
RE: How to Configure Memory
SQL1: To allow SQL Server to use more than 2GB of memory, AWE needs to be enabled.
SQL2: Well, SQL will always leave about 180MB (I think that's the amount, could...
-
RE: Distinct Count
Î was amazed to find that a normal SELECT COUNT(DISTINCT columnname) FROM SOMETABLE didn't work... Thought Access 2000 supported most of the syntax in SQL 2000. Well, this query works...
-
RE: Unknown person probing my database security
quote:
http://www.nextgenss.com/software/ngssniff.htmlDavid, I've been trying to download both NGSSniffer and NGSSquirrel a while now,...
-
RE: Installing SQL2K on W2K professional
The only editions of SQL Server 2000 that can be run on Win2k Pro is Personal, Developer and Desktop. All of these are limited by a concurrent workload governor. Desktop...
-
RE: Clustered or NonClustered
quote:
The clustered index is stored as actuall data so you will need more space to store and use such an index. -
RE: Sending a list to stored proc (almost got it!!)
I would avoid the temporary table if possible. Just wrote an answer to a similar question on another forum, I'll cut & paste it here and you can change it...
-
RE: Ideas For Down Time???
* Play Fussball
* Play snooker
* Sit in the sun and drink beer
Forgot: Read a good SQL book!
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Edited by -...
-
RE: better than a clustered index
katravax, you are absolutely right. My mistake of course, don't know what I was thinking of.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
-
RE: Sql Questions needed for "new hire" test!
I would give them some question where the easy answer would be a cursor, but the little-bit-harder answer would be a set-based solution. Not too difficult of course, just to...
-
RE: Maximum query string permitted in SQL (7.0 or 2K)
Have you tried changing the network packet size configuration option with sp_configure?
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
-
RE: The "in" syntax
I tried this on Oracle now and it was as I thought, the results where:
a b
---
1 2
1 2
So, the correct SQL Server version of the Oracle example you gave would...
-
RE: SQL Logon
If I understood you correctly, you want to change the password of the domain user that SQL is running as. After you've changed the password, just make sure to update...
Viewing 15 posts - 1,351 through 1,365 (of 1,412 total)