RE: Performance Problem
Chek the use of indexes, if the are not the same try to Hint them:..................FROM Table1 (INDEX = idx_index_name)............ Sometimes if you use calculation in the joins it does not use the right index.
2005-04-28
NoSQL
RE: Challenge for SQL Gurus: Grouping and outer joins
WOW... and I thaught I was starting to know something about t-sql. Where did you learn to do that?? (I know it's just a little trick but still it's not that obvious to do).
2005-04-20
2005-04-18
RE: Replication Question
In reply to Scott's question, I will be inserting rows in the same tables as the replicated data, but I would not be updating any rows that were originally replicated. However, he indicates this would be an issue even if just inserting data.I do need clarification on Hilary's reply. She says "by default replication will […]
2005-04-14
RE: Obtaining error message information in alerts and jobs
Look in Books OnLine for sp_add_jobstep where the specifaction for the @command can include one or more of the case-sensitive tokens which are replaced at run time. These token are not availalbe under query analyzer but only is a job that has been invoked by an alert !Be sure to wrap the tokens with double quotes […]
2005-03-03
RE: What is the difference between user-defined function and stored procedures in SQL server 2000?
tymberwyld, You are correct and the rest are also correct just you are both talking about different things. Table-value functions are executed once and the join is performed once, but SCALAR functions which for some unknown reason to me seem to be Very popular are really executed on a row by row basis and even if […]
2004-08-31
RE: Transactional Replication - staged sync
1. SQL Server does not consolidate transactions in any way. In your first example - all 12 transactions are distributed to the subscribers. As far as rows inserted "out of order", SQL Server's using the transactions as they appear in the log, and not reordering them in any way. 2. The generation of a snapshot […]
2004-08-27
RE: High usage of memory
That is the nature of SQL Server, It allocates as much as it needs.You can limit max memory SQL Server can use by configuring the min and max memory from either EM or sp_configure command.Use performance monitor to watch how SQL Server consumes memory and other system resources.
2004-08-20
Question of the Day for 14 Sep 2004
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-08-16
XP_sendmail and mapi profile
Hi EverybodyI hope there is somebody out there who can help me. I am trying to setup notification on MS SQL Server 2000-8.00.760 (Intel x86). Enterprise Edition on Windows NT5.0 (Build 2195:Serice PAck 4).I have setup a mail profile using Internet mail server (POP3/SMTP). The client on the SQL server is Outlook 2000. Our e-mail […]
2004-08-13
44 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