INDEX DEFRAGMENTATION SCRIPT for SQL server 2000
Advertisements
INDEX DEFRAGMENTATION SCRIPT SQL 2000
Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance....
2011-03-12
1,894 reads
Blog Posts
Table-Valued parameters in SQL Server 2008
Introduction
The
most awaited feature has arrived - "Table-Valued parameters in SQL Server
2008". Here, I would discuss on how to use this new...
2011-03-12
4,530 reads
A Small Collection of SQL Azure Queries
We have been doing some more work with SQL Azure lately, so I have put together a small collection of...
2011-03-11
2,558 reads
MagicPASS March 2011 Meeting Notice
If you're in the central Florida area you're invited to the March meeting of MagicPASS, South Orlando's SQL Server User...
2011-03-11
484 reads
Monitoring Database Infrastructure and Performance with Systems Center Operations Manager (SCOM), and Oracle Instance Monitoring, Plus Visio Plug-In
SCOM Does the core job of monitoring SQL Server instances very well (Health Monitoring) – but it is not going to...
2011-03-11
8,992 reads
My Heart Goes Out to Japan's Earthquake/Tsunami Victims, And I Pray for Rain in Kesennuma Tonight as the City Burns....
Already hit by yesterday's Tsunami, the fires have taken over the main center of town in Kesennuma, Miyagi, where I...
2011-03-11
1,127 reads
Poll: – Index Rebuild / Defrag, what page count filter do you set?
After reviewing a number of clients overnight index defrag / rebuild scripts over the years, I’m intrigued to know how many...
2011-03-11
748 reads
Attending SQLskills Immersion Event on Performance Tuning Next Week
After attending the SQLskills Immersion Event on Internals and Performance in Dallas two weeks ago, I am fortunate enough to...
2011-03-10
817 reads
Do You Enable “Lock Pages in Memory”?
Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not...
2011-03-10
3,113 reads
Interview with DBA Brian Kelley
Brian Kelley will be speaking at the SQLServerCentral.com track at SQL Server Connections, March 27-30, in Orlando, FL.
Tell us a...
2011-03-10
936 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
ALAMAT KONTAK BCA KCP Alaydrus Telp:08218154392
WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...
ALAMAT BCA KCU RAWAMANGUN Telp:08218154392
WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat Kantor BCA KCU City Tower Telp:08218200233
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers