One of the issues I often face is the need to find views that are already established for certain tables. This maybe for other developers, end users or even for myself. I could search the system tables to find this or explore each view, but are there other ways to easily find a list of all tables that are used for a view or even a list of all views that a table is tied to?
2008-12-12
3,940 reads
This article describes how an index gets fragmented and the steps which a DBA can take to fix index fragmentation
2008-12-11
2,876 reads
Maintaining a database often means schema changes. Before you change or delete anything, be sure to check for dependent objects.
2008-12-11
2,638 reads
Learn how to configure SQL Server database storage with higher disk writes than disk reads. Set up a RAID 10 array, cache configuration and file disk layout.
2008-12-10
3,222 reads
Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.
2008-12-10
4,663 reads
In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based on Service Broker worthy of the SQL Server Agent itself.
2008-12-09
2,872 reads
There is value in using the extended properties across some of the industry leading data modeling tools. What if I do not have access to any of those tools? Is it possible to build the extended properties and then be able to generate reports by using Excel or Reporting Services?
2008-12-09
4,930 reads
A great presentation from Paul Randal of SQL Skills from TechEd 2008. Definitely worth the time to watch.
2008-12-08
5,046 reads
I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?
2008-12-08
2,297 reads
Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function.
2008-12-05
1,889 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Comments posted to this topic are about the item The Large Encoded Value
Comments posted to this topic are about the item The Side Job
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers