Distributed Queries

Technical Article

RE: QOD 17th Nov

  • Reply

"This is a poor question" OK, well, thanks for the skewer. I'll think twice about posting a question from now on. ;-/ I represented it as I found it, did look in BOL, and did not find anything to contradict the author's comment. I have experimented with it as a feature, and have found that […]

2003-11-17

1 reads

Technical Article

Middle Tier Application Data Caching with SQL Server 2000

  • Article

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.

2002-03-08

2,221 reads

Technical Article

Replication with tables whose owner is not dbo

  • Topic

I am trying replication in sqlserver 7. My source db has table owners different to dbo. When I trying replication, it searches for tables in the destination server as dbo and not as the owner which is there in the source db. For example in source db has db1.system.emp_master but it tries replication with db2.dbo.emp_master […]

2002-01-13

1 reads

Technical Article

Creating a stored procedure with infinite variable

  • Topic

hi can anyone help. I am new to the SQL Server. I need to input data into a column with the PK (Primary Column) From other 2 tables I am using a stored procedure to store the data. Table1 NameID FirstName LastName 1 Sam Smallwood Table2 ID NamesofCD 1 CD1 2 CD2 Table3 NameID ID […]

2001-11-20

2 reads

Technical Article

DTS prob. In SQL 2000

  • Topic

Log file creation differs between DTS and VB Module? Why? I created a DTS package in SQL-2000 with Win2k server. I saved the same DTS package as VB module. Then i tried to execute the same thro' VB. It is running fine in both the ways. It is creating a log file in dtssteplog table […]

2001-11-18

1 reads

Blogs

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Case statement with time

By pedroccamara

Hello everyone I hope everyone's ok. I have this query and I'm trying to...

what are the best books to become a SQL developer?

By vpmaciel

what are the best books to become a SQL developer?

what are the best books to become a DBA SQL?

By vpmaciel

what are the best books to become a DBA SQL?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers