Additional Articles

All authors

External Article

Manipulating Multiple Objects in SQL Server Management Studio

Every now and then, I see someone doing repetitive tasks in SQL Server Management Studio such as dropping a stored procedure one by one when they need to remove ten or scripting out a single object at a time because they can't select multiple objects from the Object Explorer. I have even seen people create elaborate scripts to perform tasks that involved manipulating multiple database objects to avoid these mundane tasks. In this tip I will show you how this can be done simply by using SQL Server Management Studio.

2010-01-11

5,770 reads

Technical Article

Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)

Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:

2010-01-08

5,310 reads

External Article

Application and Multi-Server Management

This paper introduces the new extensions in SQL Server Management Studio and the Control Point Explorer, and it walks through the simple process of setting up a SQL Server managed server group, including SQL Server Control Point installation, enrolling an instance into central management, extracting Data-tier Applications from existing deployments, and deploying Data-tier Applications to the new managed server group.

2010-01-05

2,161 reads

Technical Article

Top 10 steps to optimize data access in SQL Server. Part I (Use Indexing)

’ll focus on the issues that you need to follow to make sure that you have done everything that you could do to optimize the data access codes you have written or you are going to write in future. The Database Administrators (DBA) also has great roles to play in optimizing and tuning the database performance. But, optimization scopes that fall into a DBA’s area are out of scope for these articles.

2009-12-29

5,922 reads

All authors

Blogs

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them

By

PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...

A Cloud Dependency Failure from Amazon

By

I went to sleep while reading a Kindle book on my phone. I know...

Deploying AI in logistics (the unfiltered version)

By

A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...

Read the latest Blogs

Forums

BCA KCU KEBAYORAN BARU Telpon/WA:085355042311

By noumanarshad

BCA KCU KEBAYORAN BARU Telpon/WA:085355042311 Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec....

BCA KCP Dewi Sartika HUB/CS 08216977749

By noumanarshad

Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta Timur, Daerah Khusus...

Kantor BCA KCP Jepara Telp/wa 085169998803

By Exam Alert

Telp/wa 085169998803 Jl. Pemuda No.28-32, Panggang III, Panggang, Kec. Jepara, Kabupaten Jepara, Jawa Tengah...

Visit the forum

Question of the Day

Creating a JSON Document III

I have this data in a table called dbo.NFLTeams 

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960
If I run this code, how many rows are returned? 
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers