Viewing 15 posts - 5,176 through 5,190 (of 6,104 total)
Do the maintenance jobs run about the same time as you are seeing the drop in buffer cache?
K. Brian Kelley
August 12, 2002 at 8:42 am
Are the web users not able to execute the stored procedures currectly? What's not working?
K. Brian Kelley
August 10, 2002 at 2:40 pm
There are also some articles around the web with regards to integrating VSS more tightly with SQL server... rather than using it just as a repository of scripted databases. We've...
August 9, 2002 at 9:38 pm
If you're using SourceSafe, one thing you can script the whole database. As long as you use the same scripting options each time, you have two scripts which are comparable...
August 9, 2002 at 7:06 pm
As long as the login used (SQL Server or NT) has sysadmin rights, you should be fine. We use NT logins all the time.
K. Brian Kelley
August 9, 2002 at 7:01 pm
Starting from the top: Can you send and receive email from Outlook with the profile?
K. Brian Kelley
August 9, 2002 at 9:25 am
I may monitor it long term, but I don't have an alert set up on it. At the times the alert fires, what else is going on? Is there a...
August 9, 2002 at 9:22 am
Typically, we don't consider the order of columns important in RDBMSes, as we can always specify order in our queries. If it is important in your case, however, there's no...
August 9, 2002 at 9:19 am
Is SQL Server the only memory-intensive application on the system?
K. Brian Kelley
August 9, 2002 at 6:51 am
August 8, 2002 at 2:08 pm
There's a system function which does the conversion in SQL2K. Take a look at dbo.fn_varbintohextstr and see if it fits your needs.
K. Brian Kelley
August 8, 2002 at 10:45 am
I agree that when the author is available to respond to questions, that's always great. I think I had a question on DTS and was able to send to Brian...
August 8, 2002 at 9:35 am
Have you tried running DBCC SHRINKFILE with first the NOTRUNCATE option to move all the data to the front of the file followed by running it again with TRUNCATEONLY to...
August 8, 2002 at 7:27 am
I remember having problems converting varbinary strings myself (a Citrix Metaframe XP datastore has a few columns which are binary) but eventually plugged through with the help of a function....
August 7, 2002 at 6:29 pm
The only applicable knowledge base article dealing with clustering that pulls up on replres.dll is a SQL Server 7.0 one.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q254593
I'll try to remember to look at my clusters tomorrow...
August 7, 2002 at 6:23 pm
Viewing 15 posts - 5,176 through 5,190 (of 6,104 total)