Discuss Content Posted by Jeffrey Yao
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Jeffrey Yao
2004-02-29
1 reads
Distributed Queries
RE: QOD 17th Nov
"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
Discuss Content Posted by Andres Taylor
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Andres Taylor
2003-10-31
5 reads
Discuss Content Posted by Ram Kishore
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Ram Kishore
2003-10-27
2 reads
Review of SQL 2000 Fast Answers
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
2003-04-18
18,230 reads
Adding Linked Servers Using SQL-DMO
Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.
2002-09-19
12,152 reads
Middle Tier Application Data Caching with SQL Server 2000
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
Replication with tables whose owner is not dbo
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
Creating a stored procedure with infinite variable
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
DTS prob. In SQL 2000
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
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
Join Denny Cherry and Associates at SQL Bits 2023
I am very excited and lucky to be speaking once again at SQLBits along...
Daily Coping 27 Jan 2023
By Steve Jones
Today’s coping tip is to try something new to get out of your comfort...
Forums
Case statement with time
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?
what are the best books to become a SQL developer?
what are the best books to become a DBA SQL?
what are the best books to become a DBA SQL?
Ask SSC