Since you mention ASP pages, I assume this is a web application. If your users are authenticated (NT Domain or AD) users, you can use the first or second option, as long as you purchase a CAL (client access license) for each individual user that will be using the system. If your users are not authenticated, you […]
2004-01-27
in addition to the other replies:- If you know you'll need 13,5 Gb why do you try to shrink to 4 Gb ? This way sqlserver will have to allocate extra extentions (cfr autogrow). use [MSQLDB] DBCC SHRINKFILE (N'MSQLDB_DATA', 14000)- Is your database in use (locking / blocking) ?
2004-01-26
2 reads
How do we do that on the client side? Add/set a parameter in the program (e.g. TSQL, VB script,etc)?
2004-01-25
Also, don't use a UDF to convert dates to YYYYMMDD, just CONVERT(char(8),YourDate,112). The native function (and implicit conversion if the result is going into an int column) will be faster than any UDF, and you'll appreciate this speed if you're actually updating an entire table.True. Didn't see the 112 in the list.....
2004-01-23
Actually, SQL server will search for <owner>.<object> where <owner> is the current user. If it doesn't find an object matching, it drops back to dbo.<object>. Unless, of course, it's a stored procedure that begins with sp_ in which case it searches for it as master.dbo.<sp_ name> first. Prior to Yukon schema and user aren't separated […]
2004-01-23
1 reads
Chris, Have you configured the security for the IUSER account??? It looks like a permissions thing currently. I assume you are using IIS and I think you wil need to grant permissions to that user for your app to work. I don't work with ASP that is just what it looks like from the blurb you […]
2004-01-22
Might be worth considering placing a DEFAULT value of 0 on your column, otherwise you'll face the problem you know have.Another approach might be to use COALESCE() like thisSET NOCOUNT ON CREATE TABLE AveragingMultipleColumns (year0 DECIMAL(8,5), year1 DECIMAL(8,5), year2 DECIMAL(8,5))INSERT INTO AveragingMultipleColumns (year0, year1,year2) VALUES(1,2,3) INSERT INTO AveragingMultipleColumns (year0, year1,year2) VALUES(1,2,NULL) INSERT INTO AveragingMultipleColumns (year0, […]
2004-01-22
1 reads
Thanks kknudson. I put the offending server in its own group and collapsed the group and no more network traffic. I also upped the time between polling the servers to 60 seconds from 15 seconds
2004-01-22
You need consider where is your current SQL binaries. On the cluster, SQL binaries need on the shared cluster drive.
2004-01-22
You can perform full backup to MSDB no matter it is in simple or full recovery mode.
2004-01-22
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers