BULK recovery mode and DBCC DBREINDEX
Will changing to bulk recovery mode before running DBCC REINDEX help you avoid large log files? András investigates
2007-10-02
2,168 reads
Articles
Data Warehouse Quality Assurance Best Practices
Collaboration between IT and the business will help identify the reasonable issues versus the issues that cannot be resolved for the current release of the data warehouse.
2007-10-02
2,482 reads
Monitoring Disk Space and Sending Alerts with TSQL
Haidong discusses the importance of monitoring disk usage over a period of time and has some great TSQL code to help you do the monitoring!
2007-10-01 (first published: 2003-08-13)
54,176 reads
Working Your SOX Off
The Sarbanes-Oxley act has drastically changed the jobs of many DBAs with the audit and reporting requirements this act entails. Brandie Tarvin brings us some hints about how you can go about complying with the new requirements.
2007-10-01
3,803 reads
SqlCredit – Part 9: Message Authentication Codes
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers searching encrypted data, dictionary attacks, and look-ups by hashed value.
2007-10-01
1,557 reads
The Puzzle of 'Rating Decomposition'
When reading rating information, how do you you knew how many points each separate voter gave if you only know the average rating and the number of votes? Well, you might be surprised to learn that you can figure it out using SQL
2007-10-01
1,919 reads
Conditional Statements in WHERE Clauses
T-SQL is a powerful language, enabling you to handle many different types of set based operations. But having flexible WHERE clauses isn't something that many DBAs deal with on a daily basis. New Author Sotiris Filippidis brings us an article on how you can structure a WHERE clause to handle all types of strange business logic without using dynamic SQL. Read on to learn more about his technique.
2007-09-28 (first published: 2004-07-26)
40,168 reads
Moving the SQL 2005 System Databases
Most SQL Server instances are installed with the default values, but that's not always the way it should be. Often there is the need to "move" databases to comply with standards, free up disk space, or some other reason. Moving the system databases can be a little tricky, but author Vince Iacoboni brings us his code and technique for easily doing this for SQL Server 2005 databases.
2007-09-28 (first published: 2006-09-26)
35,776 reads
Isolation Levels in SQL Server 2005
Isolation levels are used to prioritize the acccess to a resource. SQL Server 2005 extends upon the support for isolation levels in 2000 with several new features including an additional level.
2007-09-28
4,452 reads
SqlCredit Part 8: Comparing Encrypt/DecryptByCert and Encrypt/DecryptByKey
Continuing with this series looking at encryption functions.
2007-09-28
2,381 reads
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers