I thought I remembered this one, from SQL Server Magazine UPDATE, May 3 2001... * TIP: MAXIMUM ROW SIZE (contributed by Richard Waymire, rwaymi@microsoft.com) Q. How can I find out the maximum row size for a table in which all the varchars are fully populated? A. The only way to find a SQL Server table's […]
2003-05-12
1 reads
Dalton, Try this: if not isNull(objRS("faxnr")) and objRS("faxnr") <> "" then Response.write "Your fax number: " & objRS("faxnr") end if Jeremy
2003-05-12
Thanks ! Why do you think they setup diagrams for tables only ? Maybe I am doing things the wrong way - I use Views to link with other views to create final data view for Reporting.
2003-05-09
What I am looking for is a way to get and put messages to an MQSeries queue from a SQLServer stored procedure, or a way to move rows from a table into messages on a queue. We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect? To be […]
2003-05-09
quote: We monitor MQSeries with TBSM and a SQL backend, bit expensive. What are you looking to collect? To be frank I'm not totally versed in MQSeries but I have experts here that are. Speaking with our MQSeries guys they can dump our queues to a comma-delimited file at any frequency, the rest would be […]
2003-05-09
1 reads
On my list to do this weekend, but I have to build my stylesheet to add to my website. BTW, is Eurgeeka officially dead? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-09
1 reads
Ok, thanks. Know I have some hour to handle this manualy instead 🙂 Have a good weekend. /Joel
2003-05-09
1 reads
Void, Could you please make the post. We are running about 6 installations of SQLServer and use 1 mailbox only for all emails from SQL. Our sysadmin team are updating to exchange 2000 and therfore the mail server is continually going down, thus breaking some of our batch jobs overnight. I love getting the email […]
2003-05-08
2 reads
schedule as a command. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-05-08
I agree make sure you are using SET DATEFIRST to set the first day. However if you still have troubles then consider creating a sliding process to slide the dates back the number of days to bring in line for the calculation only.
2003-05-08
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
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