By tag: mssql
0
kicks
Pay attention if you manage SQL Server 2000 and 2005 - Microsoft Secur
A compulsory QFE to apply when you are running MS Office and SQL Server 2000 products.
0
kicks
SQL Server: Applying Filter on sp_MSforeachDB
Working on multiple databases on a single instance, sometime you need to execute a query for each database and for that sp_MSforeachdb is the best choice. BUT a wast majority of SQL Server user don't know how to apply filter on sp_MSforeachdb.
0
kicks
SQL Server: Controlling SQL Server Log Information
SQL Server Log, being a big source of troubleshooting and error finding, is necessary to manage properly to take full advantage.
0
kicks
SQL Server : How to Keep Database Restore History
There are many ways to get database backup set history. But what if we have restored a database from wrong backup set and later after several days need to know which backup we have restored. How...
0
kicks
Enhancements in SQL Server 2012 Management Studio
SQL Server 2012 brings some of the most desired enhancements in the Management Studio to simplify manageability. This post explores some of the key features in SSMS 2012.
0
kicks
SQL Server : Tables Relationship Diagram Using TSQL Script
How do you create relationship diagram/report between tables of a given database ? Mostly people use Database Diagram for this purpose, but this can be achieved by TSQL script.
0
kicks
SQL Server : @@VERSION Showing Incorrect Service Pack Information
Why I will not trust @@version to investigate Installed SQL Server Service Pack information ..
0
kicks
SQL Server: How Local Variables Can Reduce Query Performance
It’s a common practice by database developers to use local variables in stored procedures and scripts to place filter on basis of these local variables. YES, these local variables can slowdown your queries. How ???
0
kicks
New features for database developers in SQL Server 2012
* Paging got simpler and more efficient
* Sequences have been introduced; better performance for auto-generated IDs and easier to have IDs unique across tables
* FileTables have been introduced : building upon the FileStream feature now we can have non-transactional access to files stored in t...
0
kicks
Are you ready? (Reasons why I failed a SQL Server DBA Job Interview):
How to excel at a SQL Server DBA Job Interview
0
kicks
Sequential Guid Algorithm – Implementing Combs in .NET
A class for generating mostly seqential guids (for loads under 1K/second) across system boundaries.
0
kicks
How to Compare / Test the Equality of two Queries in SQL Server
Compare / Test the Equality of two Queries in SQL Server using this short T-SQL
0
kicks
10 reasons why I chose MySQL over MSSQL2005 Express
10 reasons why to choose MySQL as database engine for your websites instead of MSSQL 2005
0
kicks
SubSonic based Plugin for MS Sql Server 2005
Looks like someone cooked up a plugin for MS SQL Server 2005 that generates your SubSonic model, proces, etc. Note - I haven't used this at all yet.
0
kicks
Creating a mailing list from scratch
a series of posts that create a mailing list application using c# and sqlServer express