Viewing 15 posts - 61 through 75 (of 295 total)
SQL Standard edition only supports 2GB of RAM regardless of any switch you use in the OS.
Full stop - no exceptions
Hence you saw no difference.
You need SQL Enterprise to use...
September 15, 2005 at 6:43 am
Try -R as a switch on your BCP to pick up client regional settings, no need to change anything else
September 14, 2005 at 3:40 am
You could write your own, but why are you not using the server vendor tools?
for example, dell server , dell tools
On a compaq server, you can set up (I forget...
September 7, 2005 at 7:33 am
DECLARE @codesnippet varchar(100)
--Amend here to insert wht you are looking for
SET @codesnippet = 'wantedword'
SELECT DISTINCT LEFT(DB_NAME(), 20), (LEFT(OBJECT_NAME([id]), 40)) AS ObjectName
FROM dbo.syscomments
WHERE [text] LIKE '%'...
September 6, 2005 at 9:57 am
I've ran queries against the same server with standard 100MB and then with my PC switch port put down to 10MB. Same query, same row count took over 3 times...
September 6, 2005 at 7:21 am
I have done this on remote SQL Servers that we administered over the internet.
We used tcp only and installed a certificate on the SQL Server, then used the "Server Network...
September 6, 2005 at 6:57 am
When you connecting to a SQL Server install (simply), say "SQLServerBox" it looks for the computer name in DNS, resolves this to IP address, then connects to that.
SQL Server (2000)...
September 6, 2005 at 6:04 am
following on, SQL 2000 SP3a does recognise hyperthreading and uses "4" cpus but only requires 2 CPu licenses
September 6, 2005 at 5:55 am
Or using ANSI-92 SQL, rather than the archaic ANSQL-89 (older Sybase, SQL 6.5) join-in-the-where-clause
update products
set qty = a.qty - b.qty
from products a JOIN (select product_id, sum(qty) qty from invoice_product group by...
September 6, 2005 at 5:52 am
SET XACT_ABORT ON will abort your batch (up until the next "GO") if there is an error.
IF you issued a "BEGIN TRANSACTION", it will be rolled back.
Testing for @@ERROR after...
September 5, 2005 at 8:18 am
The error will NOT be in the database.
Databases don't generate PDFs!
Something else does that needs a trigger or check to start the PDF process.
If you have 2 databases on the...
September 2, 2005 at 5:36 am
Probably, if you using the sp_OA,,, procs for example or xp_cmdshell
September 2, 2005 at 5:19 am
Live server permissions then?
September 2, 2005 at 5:07 am
Why do you think this is a database problem?
Does the SQL Server generate a PDF?
Is the customer data being written into the live db? Such as tighter security on live?
Same...
September 2, 2005 at 4:33 am
Viewing 15 posts - 61 through 75 (of 295 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy