XML performance
Has anyone got any figures of the effect on the server of processing XML in the database. I am currently of the thinking that to gain the most out of the server XML should not be used in the database. Any thoughts?
2001-08-08
8 reads
monitoring
Problem with linked server query
One of the developers at my company receives the following error when executing a stored procedure : Server: Msg 7399, Level 16, State 1, Procedure forex_Insert_Positions, Line 51 OLE DB provider 'SQLOLEDB' reported an error. [OLE/DB provider returned message: Syntax error or access violation] The error occurs when attempting to select data from a linked […]
2001-07-31
6 reads
Views vs Temp Tables in Queries
Generally speaking, if you have a query with several views joined (also with several tables), do the views optimize as well as having temp tables with indexes on the foreign keys?
2001-07-19
3 reads
CHECK CONSTRAINTS
Is there any way to customize the error message of a Check Constraint? SysMessage 547 is quite complex for a simple User.
2001-07-17
2 reads
Using Xp_sendmail With the Recipients Generated From a Query
Xp_sendmail is a great utility that SQL Server provides in order to e-mail messages directly from SQL Server, by using a valid MAPI profile. However, its syntax is rather stringent. In this article by Kunal Das, he shows you how to send messages to a list of recipients generated by a query dynamically in T-SQL.
2007-10-02 (first published: 2001-07-16)
23,663 reads
DBase5 - SQL 7.0 conversion. Null Date Field.
I want to convert DBase5 table to SQL Server 7.0 table with DTS package. The DBase5 table have DATETIME field, that may have Null value. To convert the field I use ActiveX script. When I "Test" conversion it give me error on the first DBase5 record were field value is Null. I try "On Error […]
2001-07-10
21 reads
Using Java to Encrypt Passwords
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/lsmith/usingjavatoencryptpasswords.asp
2001-07-09
6 reads
Job to Monitor SQL Server 7.0 Performance and Activity
This article describes the ActivityTrace7 job that puts blocking and performance data into a trace file for further analysis.
2001-06-19
2,670 reads
Sweeping Up The Slackers
Have you ever worked with an application that forgot to close its connections? Ever run out of connections on your SQL Server and had to manually go remove the ones that are not in use? This article will present a technique for keeping the database clean.
2001-05-07
5,088 reads
Automatically Gathering Server Information Part 8
The eighth part of Steve Jones's series on having SQL Server automatically report information to a DBA.
2001-04-29
6,627 reads
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