2005-05-11
count()
replication conflict monitoring
So, I have an interesting problem that I'm trying to work out. In my merge replication environment, I get the occasional replication conflict(s) in some of my databases. I'm not exactly looking for a solution to solving those, but what I am looking for is a better notification scheme for when they do occur.I don't […]
2005-03-10
2 reads
RE: sp_executesql help
See "Arrays and Lists in SQL Server" by Erland Sommarskog (SQL Server MVP) at http://www.sommarskog.se/arrays-in-sql.html
2005-03-10
1 reads
RE: Performance? Efficient code??
In answer to Antares686:I've tried the code, but instead of the 1578 rows that I was hoping for I received 4755 in the result set. This code basically gave me a union of the two sets minus the 9 duplicate entries that I know we have. I'm still trying to figure out your code to […]
2005-03-10
RE: Designing Cross Database Queries
Question: Referential Integrity?When you have these cross-database (and linked servers, etc), how do you maintain referential integrity?eg, bbdpres:We have an environment for reporting here that needs to use dynamic aggregations on products. The product aggregations are on what we call market definitions and product groups (1-m-m; market def-prod grp-prod). Users have the ability to add […]
2005-03-10
1 reads
RE: How to get available memory using SQL
It's not a table : run this in the master table Select objectproperty(object_id('sysperfinfo'), 'TableIsFake') It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table. checks BOLS : objectproperty::TableIsFake
2005-03-02
how to tell if an index is being used in a query...
Is there a way other than the Index tuner to tell if an index is being used in a query?
2004-10-20
RE: read text file contents in a stored procedure
Forgot one thing...If the @noErr variable is 0, you may want to set @out_contents as'ERROR - Handle: ' + @hr + '; Method: ' + @errMethod + '; Source: ' + @src + '; Desc: ' + @desc Hope this helps...
2004-09-22
RE: Incorrect rowcount when viewing table properties
A rowcount can be done in two ways:Most accurate and slowest: SELECT COUNT(*) FROM MyTABLELess accurate but instant: SELECT ROWCNT FROM Sysindexes WHERE ID = ObjectID('MyTable') AND Name = 'MyTable'That rowcount is used by EM and is kept uptodate with the 'Auto Update Stats' setting for the database. But sometimes it's out of sync. So you need to […]
2004-09-10
RE: Stored procedure Returning XML String
It's ok now, I have it working, The Order By was breaking the SP. Thanks for the helpDave
2004-09-10
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