If you create functions or stored procedures from SQL Server 2005 Management Studio, you will notice that the new window is filled with a template. In general, you get a skeleton interspersed with markers. This article discusses how you can use templates.
2006-11-02
2,522 reads
DW/BI professionals are often tasked with making evolutionary upgrades and improvements to minimize cost and upheaval in the current analytic environment. We explore four upgrades that can breathe new life into legacy data warehouses.
2006-10-31
2,682 reads
If your SQL Server app is suffering from poor performance and you suspect a missing index, then read on
2006-10-30
2,990 reads
Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract
2006-10-27
3,089 reads
SQL Server 2000 and 2005 do not include much in the way of financial functions, but there are many sources for the formulas for financial calculations. In this tip, I present the present value (PV) and future value (FV) functions, both of which are scalar UDFs.
2006-10-26
2,458 reads
The definitively "hands-on" guide to handling dates and times in SQL Server
2006-10-25
2,883 reads
In this and the related articles, we will overview Actions in Analysis Services 2005. Much as they did in the previous version of Analysis Services, Actions allow information consumers to go beyond the robust OLAP perspective offered by Analysis Services, and to "step outside" for related information, or to generate commands or initialize programs, without leaving their current analysis focus.
2006-10-24
2,654 reads
Learn how to make life easier by dividing large tables and indexes into smaller parts.
2006-10-23
3,774 reads
It's small and neat but it might just save your data...Robyn Page's crib sheet tells you everything you wanted to know about SQL Server backup but were afraid to ask.
2006-10-20
4,868 reads
Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules.
2006-10-19
3,998 reads
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Comments posted to this topic are about the item Admin Rights for Everyone
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
Comments posted to this topic are about the item RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers