Somehow you are not running the last SQL I gave you. I know that because ANAvn isn't in it anywhere. Do not put this SQL into the stored procedure at all. It is only for problem analysis and should be run all by itself. Leave the SP alone for now.
2004-10-07
2004-10-05
I'm sorry for the typos.The database file and log files are accessible.So what should i do now? Please guide me from here.
2004-09-29
"Is the number of reads in any way responsible for the time a query would take to execute?"YES. Time spent on too many reads on the index (and data) add to the the query time. As simple as that. It is one of the most influential parameters. Other causes for affecting the query time also exist, […]
2004-08-19
how about :EXEC master..xp_logininfo @acctname = 'yourdomain\yourgroup',@option = 'members'
2004-08-11
I've found out that the maximum buffer size ia actually 1Mb or thereabouts based upon 250 x 4000 nvarchar strings. I now wonder if the conversion to nvarchar occurs for each string thus converting a 8000 varchar to 4000 nvarchar, would I loose chars from my varchar ?
2004-07-28
I played around with it for personal interest sake.CREATE TABLE #tmp( XMLContainer TEXT)INSERT #tmp exec master.dbo.xp_cmdshell 'type myfile.xml'Once you have done this then you can use the built in SQL XML extensions to play around with your file.
2004-06-30
Without getting into the specifics, the Clariion that we have is an upgrade from 7 year old Symmetrix. The test server is a HP dual Zeon 2.8GHz compared to our production HP dual PIII 550 MHz. Ram is the same in both. It is hard to do performance monitoring on the test server connected to […]
2004-06-29
Hi collin I dont know the answer to your question however now I know where you get your help.Dirk
2004-05-20
Your going to have to use ActiveScripting and the VBScript examples you saw. We have something doing this now and I can share the code just email me, however keep in mind Crystal has to be installed on the server or location that will start the DTS package.
2004-03-29
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