Technical Article

Server Side Paging using SQL Server 2005

A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client's paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP clauses and weren't very efficient. Using Common Table Expressions in SQL Server 2005 we have a better way to page record sets on the server.

Technical Article

Testing - MP3

We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.

Blogs

Creating a Local Model Chatbot on Windows

By

After my session at VSLive last week, I had a few questions from the...

To refer and to be referred

By

Referrals have never been more important in the job market. They’re no longer nice...

A New Word: Dorgone

By

dorgone– adj. wondering if you could slip away from an event or group conversation...

Read the latest Blogs

Forums

Alamat Kantor BCA KCP Tendean Telp:0817.82.5533

By m4rt1n4

Telp/Wa 62 817825533 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...

Alamat BCA KCP Gandaria City Telp:0821-8200-233

By R4nt4u

Telp/Wa 62 8218200233 Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar Muda,...

Querying Multiple Tables for the Same Information

By RedSoxRay

I have about 100 Tables that are all suffixed with _Modify. These tables record...

Visit the forum

Question of the Day

Negative and Positive Numbers

If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?

See possible answers