Transferring a SQL Server Diagram
So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.
2003-11-13
11,659 reads
So you've created a diagram that you now need to transfer to a different server or database. This article will show give you a step-by-step guide on how to do this.
2003-11-13
11,659 reads
This article by Andy Warren discusses how to use if update() in your update triggers to simplify your code. They are easy to use and quite effective!
2003-11-12
18,034 reads
Ever need to find out what anniversary dates are coming up? What about a list of birthdays in the near future? This article looks at querying for repeating dates.
2003-11-11
7,529 reads
This article presents one technique to be used for removing duplicate rows in a table.
2003-11-07
15,222 reads
This is a transcript of a recent chat that included our own Brian Knight!
2003-11-07
3,412 reads
How often do you hear FUD either for or against Microsoft? Know what FUD is? Steve Jones recently ran across an article looking at reasons why you don't want Microsoft products in your enterprise, specifically servers. Here's a few comments and a link to the article.
2003-11-06
4,581 reads
This article by Andy Warren introduces some additional SQL-DMO methods that are very useful when automating administrative tasks.
2003-11-05
11,525 reads
myLittleTools.net is pleased to announce the release of its web-based MS SQL and MSDE database administration tool. Several tools have been added, including "BackUp and Restore database" tools, "CSV Import" tool, "Generate INSERT scripts" tool, "Detach/attach database" tool. Several toys have also been added, including the possibility to display database space used with SVG graph, or a new skin.
2003-11-05
1,734 reads
2003-11-04
179 reads
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
2003-11-04
1,286 reads
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Buckle up, database wranglers! Nowadays, SQL DBAs hold the keys to a company's most...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
Dears, I was told that I cannot access delta files in SQL Server Managed...
Comments posted to this topic are about the item Crazy Interviews