Hi All, first i want to perform a check on column whether if its null or not null. Then i want to check the next column for not null and null condition and then concatenate those values. How I should go about doing this. Right now I'm using CASE but I cannot seem to concatenate […]
2002-01-31
2 reads
Are there any issues with having the Server Collation of SQL Server Default, but Databases with different Collations ?
2002-01-30
Hi, I have just been asked to come up with information about running SQL2000 for 1000 users. I have been able to find lots of info on large databases and scaling them, but what about large numbers of concurrent users? Are there any good references for how to setup/configure SQL2000 for this number of users? […]
2002-01-29
Hello!! I have a SQL Server 7.0 question, and was wondering if any of you had any ideas, etc.... I have a VB program that executes a select statement against a SQL 7.0 database. My question is regarding cached information. Does SQL Server do this? When this query is run, a user, for example, hits […]
2002-01-28
hi, i have a query in a Store Procedure which changes as per the parameters passed to it... following is a extract/example: -------------------------------------- declare @vSTR varchar(100), @vVAL int , @dGetDT datetime , @bVAL binary set @bVAL = 1 if (@bVAL = 0 ) SET @vSTR = 'SELECT @dGetDT = getdate()' else SET @vSTR = 'SELECT […]
2002-01-28
6 reads
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/awarren/reducingroundtripspart2.asp
2002-01-25
7 reads
Hi there, My ISP is trying to set up a db for me in SQL7. He has an error though in authentication; "The SQL Server was registered with NT users authentication. I have an option to edit that registration to SQL authentication. First, I have setup an SQL account account in SQL login manager with […]
2002-01-16
2 reads
CryptoAPI function 'CryptAcquireContext' failed. Error 0x8009001d: Provider DLL failed to initialize correctly. Customer is getting the following error on MSDE 2000 w/SP1 installed on a NT 4.0 sp6 server when ADO 2.61 is executing some SQL statements using VB. No CryptoAPI calls anywhere in the code. I had them run the same SQL statements using […]
2002-01-07
3 reads
Hi All, This is the problem I thought I have fixed yesterday. What I am trying to do is creating the dts package so that I can populate tables and other objects from one database to another. When I did this in my local sql server 7 which is on NT works fine. Now I […]
2002-01-04
3 reads
Can you recommend a program, or other means, to generate lots of DB test data (e.g. 10GB) for performance analysis? Optimally, it's easy to setup and use and doesn't cost $4000. Bill
2001-12-28
2 reads
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