RE: Baffling Sql2k backup times
We had a similar issue - backup times had gone up drastically - and it turned out that 1 of the disks in the array had gone bad - as soon as we replaced that disk - the backup time came down to normal.- DK
2004-03-09
Excel
RE: Question of the Day for 02 Mar 2004
For those that don't like the "quality" of the questions [and OK, the answers too] - try sending your own in I know I did once and got hammered pretty heavily . It's quite an art to ask a question without directly giving away the answer. I'm sure Brian wouldn't mind having a break from […]
2004-03-02
HP EVA 5000 SAN
Are there any forum members out there who are using a HP StorageWorks Enterprise Virtual Array 5000 to provide storage for multiple servers running SQL 2000 ?I would appreciate some advice on disk group sizes, location of disks for disk groups, or anything else you can think of. I've just started working for a new company with […]
2004-02-26
4 reads
Post install add SSL
I did not have SSL certificate installed when we installed RS and now have it.What steps do I need to take to inform RS to use SSL? Is it setup /rsusessl=1Or is there a better interface/switch?Thanks, Bill
2004-02-23
Report Parameters Wont Go Away
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!
2004-02-23
RE: sp_spaceused tablename for each database
And Expanding on Mohammed Excellent idea:DECLARE @SQL NVarchar(4000) if OBJECT_ID('tempdb..#T1') IS NOT NULL drop table #T1 create table #T1 ([name] varchar(60) , [rows] varchar(11) , reserved varchar(11) , data varchar(11) , index_size varchar(11) , unused varchar(11) , DBName nvarchar(128))SET @SQL = ' SET NOCOUNT ON ' SELECT @SQL = @SQL + ' INSERT INTO #T1 […]
2004-02-20
RE: inserting last record....
Thinking about it, if you do the following type of codeDECLARE @val INTSET @val = (SELECT valid FROM tblx)If multiple rows return you will get an error.If you however doDECLARE @val INTSELECT @val = valid FROM tblxThen @val will be set to the last valid from tblx that comes thru the buffer.Do you have cleanup […]
2004-02-10
1 reads
RE: Question of the Day for 10 Feb 2004
From the SQL Server books on line about raid levelsLevel 1This level is also known as disk mirroring because of its use of a disk file system called a mirror set. Disk mirroring provides a redundant, identical copy of a selected disk. All data written to the primary disk is written to the mirror disk. […]
2004-02-10
1 reads
RE: Problem deleting rows on subscriber in transactional replication
If rows do not match between Publisher and Subscriber then the Subscribers are most likely out of sync!Lets start from the beginning.(A) Did this error occur immediately after installing and configuring replication?(B) Were the subscribers dropped from the publication at any time? If so then thats most likely why they are out of sync!(C) how […]
2004-02-08
RE: Question of the Day for 05 Feb 2004
You know, this is a lot more than once that the proper answer is passed over. I guess the best thing I can say is that it's now just like the actual Microsoft Exams!
2004-02-06
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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