RE: SQL Server is taking up all my memory
Why do you want to limit the available memory to your SQL Server? You can configure "max server memory (MB)" either from sp_configure or EM.
2003-05-21
Disaster Recovery (DR)
RE: Uncluster SQL 2000
To "uncluster" them, backup up all the DBs, detach the DBs, uninstall the virtual instances, uninstall the default instances, and finally uninstall the cluster service. If it is your desire to keep those two servers as SQL servers, you'll need to reinstall SQL Server and then reattach the user databases.
2003-05-20
1 reads
Discuss Content Posted by Gheorge Ciubuc
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Gheorge Ciubuc
2003-05-16
1 reads
RE: "Cannot Generate SSPI Context"
quote: A developer in our company changed her password and since then this error has been happening intermitently. Is this just happening for SQL Server or for other services as well (file & print, for instance)? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-13
Integrating SQL LiteSpeed in your existing Backup Infrastructure
This articles makes the case for using SQL LiteSpeed over other backup solutions and presents some notes about why the DBA should manage backups rather than offloading to network administration.
2003-05-12
5,426 reads
RE: select and lock next key value
Thankyou to each of you. I will be able to use a couple of those options.
2003-05-08
RE: Restore MDF and LDF file
I've notiched that sometimes sp_attach dosn't work. Maybe you could try the command: create database cpk on primary (filename='c:\mssql\data\cpk_data.mdf') for attach
2003-05-08
RE: pinning a temp table to memory
I think using a table variable instead of a temp table will help you: DECLARE @t1 TABLE( c1 int, c2 varchar(10) ) now @t1 is a local table variable. Memory for it is allocated as long as the variable is in scope. The only disadvantage is that it consumes memory. Of course, it is much […]
2003-05-02
RE: Text Function Help
Don't really know if there is a best way. It depends on volume and type of data. You only gave example of 3 rows with one character data. The only way I know is to use loops, either a cursor and loop for each char or the following for a set based solution. Note, this […]
2003-05-02
1 reads
RE: SQL Server and Daylight Savings Time
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-04-28
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers