2001-05-13
2,725 reads
2001-05-13
2,725 reads
2001-05-11
3,000 reads
Have an older workstation with only a little hard drive space? Tired of the SQL Server tools taking about a hundred megs on your most precious drive? If you answered yes to either one of those questions, then this quick tip is for you.
2001-05-11
2,821 reads
This article by Andy Warren outlines two ways you can reduce the number of log backups you do. Includes sample DMO code.
2001-05-11
4,365 reads
2001-05-11
2,268 reads
Detaching and attaching a database is an advanced trick that can be useful in anything from transporting your database to recovering from a disaster.
2001-05-10
16,975 reads
Need to rough up some bulk test data in a hurry? A carefully thought-out Cross Join could be the answer.
2001-05-10
6,414 reads
Want to take advantage of some of the benefits of using XML for data exchange, take a look at 'FOR XML' in SQL 2000.
2001-05-10
6,086 reads
This article by Andy Warren discusses both how to use the Public Role and how using Public may cause you more problems than it's worth. Great examples!
2001-05-10
18,224 reads
In this article, Brian Knight shows you how to convert data stored in DB2 to SQL Server using DTS.
2001-05-09
7,152 reads
By Zikato
I recently encountered an issue where an index rebuild set to wait_at_low_priority ended up...
In the data-driven landscape of 2024, advanced SQL isn't just a nice-to-have, it's a...
A couple of weeks ago, a developer came to me and wanted to know...
Comments posted to this topic are about the item A Lack of Memory Grant...
hello, i am trying to find where SSRS edition and product key information...
Comments posted to this topic are about the item Baseball Everywhere
SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)
See possible answers