The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions.
2005-11-15
2,315 reads
If you are deploying Reporting Services on SQL Server 2005, you may run into an issue when installing an SSL certificate. David Russell brings us some information on what could happen and how to successfully install.
2005-11-07
13,719 reads
Backups and restores are two fundamental tasks that a DBA must perform correctly. But remembering the syntax, options, decoding filenames, etc. can often be busy work that leaves a DBA open to mistakes. New author Vince Iacoboni brings us his code and techniques for a set of stored procedures to make handling backups and restores very simple.
2005-11-07
13,498 reads
It has been nearly 5 years since SQL Server 2000 was released and almost seven since Query Analyzer was introduced in SQL Server 7. Surely every trick, tip, technique, or secret has been published by now? Perhaps, but this might be a new one from Yakov Shlafman. Check out what he thinks is the best kept secret.
2007-10-02 (first published: 2005-10-26)
76,841 reads
Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.
2005-10-24
13,644 reads
Have you ever wanted an easy way to determine if a job is running for automated checks? This might not be an easy way, but Leo Peysakhovich provides a way that works and corrects an error in Books Online.
2005-10-18
29,124 reads
2005-10-11
1,584 reads
One thing Access developers love about using SQL Server as the back end is that it is easy to do maintenance. I can't tell you how many times I toured around an office, looking for users who had their client open and connected to the data so I could ask them to log out. Too many times, the offender was at lunch or away from their desks, with their desktops locked.
2005-10-11
3,496 reads
SQL Server has the best client tools for a DBA of any RDBMS and SQL Server 2000 includes Query Analyzer, an amazing tool. There are a few places where this tool could use some improvement and Yakov Shlafman brings us a few ways that you make your work with Query Analyzer even smoother.
2005-09-29
16,266 reads
SQL Server 2000 has a great set of administrative and development tools, one of the most heavily used of which is Enterprise Manager. Sushila Iyer brings us a fantastic article with some tricks in using this tool to create and manipulate tables.
2005-09-26
16,250 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?