Introduction to SQL-DMO
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sburke/introductiontosql-dmo.asp
2001-09-26
5 reads
administration
timeout expired
This connection timeout problem occurs intermitently. I've reviewed my SQL Server 2000 configuration, applied SP1, tried all manner of connect strings and I still get 'connection failed SQLState: 'S1T00' SQL Server Error:0'[Microsoft][ODBC SQL Server Driver] Timeout Expired. Does anyone know how to resolve this issue!! Plesase !!
2001-09-25
91 reads
Shrink Database
How do I shrink the allocated space for a db. I have a database that has 26 gigs reserved but the physical space needed is 19 gigs. I want to bring that back down to 21 gigs. Steve Johnson
2001-09-24
2 reads
Roles in SQL Server 7.0
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/achigrik/sql70roles.asp
2001-09-23
4 reads
Undocumented Stored Procedures in SQL Server 6.5
This article examines some useful undocumented stored procedures in SQL Server 6.5
2001-09-21
3,260 reads
Importing text file
I'm trying to import a delimited text file into SQL server 7.0 using DTS. The destination table has four columns: the first three are varchar(255), and the fourth is the text datatype. Although @@TEXTSIZE is set to 64512, only 255 chars are being imported. The text file uses commas to delimited columns with double quotes […]
2001-09-20
2 reads
SQL 2000 in a shared web hosting environment
I've been searching the net this past few weeks looking for guidelines, best practices and security recommandations... We are offering shared web hosting to our clients and they are asking us to host their databases as well. Since SQL Server is more enterprise-based, the task of putting together a web hosting solution which include support […]
2001-09-18
nonlogged insert
Hi, I have a problem that may be very simple... Is there another way to do an "typical" INSERT from one db to another in the same SQL SERVER without logging the operation. I'm thinking most if i have a table with 5 milions rows, the transaction log gets full and no disk is available. […]
2001-09-18
2 reads
Includes in Query Analyzer?
In Oracle sqlplus, you can run a script that calls other scripts using the syntax: @<filename> How can you do so in Query Analyzer? Thanks, -Matthew
2001-09-17
2 reads
Looking for missing records
We copy tables from our production database which is a Progress DB into a SQL 2k db. Nightly on the SQL side we either truncate the table and reload the whole table or we will do an incremental update to the table. We have a table that has 14,000,000 records and is missing about 1500 […]
2001-09-17
6 reads
Blogs
Step Up Your Data Game: Learn Advanced SQL Techniques for Analysis
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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