RE: Caching Tables
Just be carefull not to overload your memory and be aware you will face a good deal of performance issues if you put too much in memory.
2003-12-03
security
RE: Log shipping and triggers
I'm afraid your strategy won't work. The receiving logshipped database must remain in "loading" or "standby" state. Any changes will break the log shipping chain. Archiving will need to be from S1 to S3. Cheers, - Mark
2003-12-01
RE: how to encrypt 500 stored procedures?
Declaring a cursor with all the sp names, and then execute sp_helptext for each one. DECLARE @sp AS SYSNAME DECLARE curSP CURSOR LOCAL FOR SELECT name FROM sysobjects WHERE xtype = 'P' ORDER BY NAME OPEN curSP FETCH NEXT FROM curSP INTO @sp WHILE (@@FETCH_STATUS = 0) BEGIN PRINT 'Scripting sp ' + @Sp + […]
2003-12-01
RE: OPENXML
Hi, Try replacing your openxml with the following: DECLARE @idoc int DECLARE @doc varchar(300) SET @doc ='<criticalityquestion> <shortform><![CDATA[Stay again]]> </shortform> <optionlabel><![CDATA[Yes;Maybe;No]]> </optionlabel> <optionvalue><![CDATA[Yes;Maybe;No]]> </optionvalue> </criticalityquestion>' EXEC sp_xml_preparedocument @idoc OUTPUT, @doc SELECT * FROM OPENXML (@idoc, '/criticalityquestion/optionvalue') WITH (optionvalue varchar(20) '.') EXEC sp_xml_removedocument @idoc quote: Hi, I am trying to extract of a particular CDATA tag […]
2003-11-27
1 reads
RE: Recover from corrupt MDF or BAK
Have you tried an "Emergency" mode recovery? http://www.tek-tips.com/gfaqs.cfm/pid/962/fid/4210 Failing that, are you in any of the Microsoft Partner programs (or anything else that gives you an allotment of help calls)? One of my colleagues once brought a very important db back from the dead (this had been corrupted by a RAID failure BTW) with some […]
2003-11-26
1 reads
RE: OT: Sybase Equivelant to MS SQL TOP?
You have to do SET ROWOCOUNT 5 SELECT ...etc Primitive There is a hell of a lot that Sybase doesn't seem to do. DBCC SHOWCONTIG, DBCC DBREINDEX etc. I've been trying to find out a way of defragging indexes and the only way that I have found of doing it is to drop and create […]
2003-11-26
1 reads
RE: Error Message
any time you get EXCEPTION_ACCESS_VIOLATION it is either because the OS is in an unstable condition or a bug on SQL Server. I would suggest a reboot and try to figure out if it is repeatable should it be the case File a bug with MS HTH
2003-11-25
1 reads
RE: HELP!! Installation questions
I frequently do this as my secondary drive is a SAN. Having the Program files on the same drive is really not an issue. The only issues you need to be aware of are: Size and Disk Contention. Size is a no brainer. And disk contention will really be an issue if you do lots […]
2003-11-20
RE: Dynamic SQL Queries
I don't know whether it's a recommended practice or not, but sp_executesql requires a Unicode constant or variable. If a constant is specified, it has to be prefixed with N, hence why the N prefix is used in this example.
2003-11-20
RE: Dynamic SQL Queries
N' turns it into unicode. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-11-20
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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