RE: #table vs @table which is better
Any good references on the nitty gritty differences between #temp tables and variable tables
2003-08-12
database mail
RE: QOD 07/30/03
I agree--the question was misleading. I thought it meant a non-Server edition of Win2K. By the looks of the response chart, so did a lot of other people.
2003-07-30
RE: Using SQL Mail on a Clustered Server
I agree with Shas3. It's doable, make sure the profile names are identical, etc. Make sure you set up the profile identically on both sides. But at the end of the day, remember that it's not fully supported and every once in a while it will hang. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish […]
2003-07-22
RE: Geometrical data
Hi Dale, quote: Check this out. I found this on Citeseer. Used that site a lot for my Masters: thanks again! Seems to be a good site. Now I only need a good pocket dictionary Cheers, Frank
2003-07-15
1 reads
RE: Proper Shutdown of SQL Servers in a Cluster
Agree with Jay_durai. I dont see a need why you are on a cluster env and need to shutodwn the nodes at the same time. If you are doing maintenance (not SQL) on the servers, perform the activities first on the passive node(designated secondary), then initiate the failure using the cluster admin and perform your […]
2003-07-14
1 reads
RE: unknown processes
With a search in the 'MSSQL\Install' directory, you can find both 'create procedures' in 2 different .sql files. The .get_perf_counters sp collects data from sysalerts and joins it with sysperfinfo. I noticed that by default you already get a bunch of those alerts (see SQL EM), you can also create them in EM or in […]
2003-07-11
2 reads
RE: Select 2 lines into 1
Each time you run 'INSERT INTO temp1 ' you create a new record. Try the following code.: create table myTemp (col001 varchar(250)) insert into myTemp values ( 'this is some text' ) insert into myTemp values ( 'this line 2 of text' ) insert into myTemp values ( 'this line 3 of text' ) insert […]
2003-07-09
2 reads
RE: ADO Code
quote: ...unfortunately not the browser merely hangs for a few seconds and then returns a blank page. any error handling routines turned on? BTW, I use this to connect to SQL Server cnnString = "PROVIDER=MSDASQL;" cnnString = cnnString & "DRIVER=SQL Server;" cnnString = cnnString & "SERVER=DCCIV30002004;" cnnString = cnnString & """;" cnnString = cnnString & […]
2003-07-07
1 reads
RE: Killing users before restore
here's a script i've used for quite a while... ------------------------ USE master go ALTER DATABASE yourdatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE yourdatabase FROM DISK = 'c:\path\filename' with replace ALTER DATABASE yourdatabase SET MULTI_USER go ------------------------ I generally run it from a batch file with something like: osql -E -d master -i db-restore.sql -o […]
2003-07-03
1 reads
RE: SQL Server software ERROR
This may or may not help, but we got the same error when someone changed the drive letter where SQL Server was installed. This might not be your issue, but I bet something was changed on the box. Linda
2003-06-25
1 reads
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