|
|
-
|
|
Microsoft SQL Server Sustained Engineering group is pleased to announce the release of SQL Server 2008 Service Pack 3 (SP3). Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. As part of our continued commitment to software excellence for our ......
|
|
-
|
|
Performance Monitor a.k.a perfmon is used to monitor different counters for different purposes. However, some counters are bit confusing. Process and Processor two misleading counters so thought of putting this note. Processor When adding processor object, you have _Total object and 0, 1 .. which ......
|
|
-
|
|
Do you think we have enough SQL Server experts? Article from Brain indicate there are shortage in SQL Server experts. “There are certainly many world-class SQL Server experts, and there have been for quite some time. I suppose it’s more of a matter if there are enough available to satisfy demand. O......
|
|
-
|
|
I am not a fan of Dilbert. But this seems to be something related to SQL. ......
|
|
-
|
|
Why Auditing? Auditing has become a must in today market environment mainly due to the fact that most security standards required. You need auditing to for following reasons. 1. Detect the system misuse and prevent it being happened again. 2. Take legal actions against the people who are respons......
|
|
-
|
|
Massachusetts recently passed a sweeping new data security law that will have a profound impact on the way the United States, and perhaps the rest of the world, manages and develops data-centric applications. Oddly, most people in the business don’t seem to know about it. Google “Massachusetts da......
|
|
-
|
|
Having discuss indexes in some what details, this post will give some queries to get the index information of you databases. Ok, if you are a DBA, most of the time you need to manage some others databases. In my carrier, it is only few occasions where I was given task to design fresh database. All ......
|
|
-
|
|
This is a setting that DBA are advised to place at the start of the stored procedure. What this setting does? Let us run an sample code for this.
USE AdventureWorks
GO
SELECT * FROM Person.Address
SET NOCOUNT ON
SELECT * FROM Person.Address
SET NOCOUNT OFF
You will that first ......
|
|
-
|
|
Having discussed about indexes into some level, now it is time to discuss new index type which came along with SQL Server 2008, filtered index.
In filtered index, you can define index to the filter portion of your data. For example, you can create a non-clustered as following.
CREATE NONCLUSTERE......
|
|
-
|
|
How many objects/features you have in SQL Server? It will range from simple Table, View to CDC, Encryption.
Let us says that you were asked to create a server trigger. Do note that DDL triggers do not have a user interface support in SQL Server Management Studio. (In case you do not know about DDL......
|
|