Blogs about: Microsoft Sql
Featured Blog
How to see sessions that are currently established in the database
set nocount on DECLARE @DBName VARCHAR(50) SELECT @DBName = ‘databaseName’ begin try drop table #tmpSpwho2 end try begin catch end catch CREATE TABLE #tmpSpwho2 (SPID INT, Status VARCHAR(1… more →
Tipsy little box
SQL stopping the shrink db
wrote 20 hours ago: Before I start this I think it’s only fair to mention that shrink db isn’t a good option … more →
Configuring an Account for Unattended Report Processing
wrote 6 days ago: You can configure a special account to use for unattended report processing (that is, to support sub … more →
Reporting Services 2008 - The report server installation is not initialized
wrote 1 week ago: If you get an error similar to the one below when trying to setup the report server. The application … more →
Microsoft SQL Databases Hosting
wrote 2 months ago: The SQL Databases Internet hosting expert services rank amongst the leading in the genre of internet … more →
Microsoft SQL Databases Hosting
wrote 2 months ago: click here Even so, if you individual a website for personalized motives or you have just started ou … more →
Database Hosting
wrote 2 months ago: Having a personal internet site usually involves getting to upload enormous quantities of facts to t … more →
How to see sessions that are currently established in the database
wrote 2 months ago: set nocount on DECLARE @DBName VARCHAR(50) SELECT @DBName = ‘databaseName’ begin try dro … more →
Varrow Madness - Session Slides
— 1 comment
wrote 2 months ago: I really hope you were at Varrow Madness with us in Durham, NC last week, because it was pretty incr … more →
Optimizing SQL Server performance for Microsoft SharePoint 2010/2013
wrote 2 months ago: This is a duplicate post from my SharePoint Community blog: http://sharepoint-community.net/profiles … more →
SQL update top n records
wrote 3 months ago: Not something I need to do very often but I needed to update the top n records on a table with a val … more →
SQL get Default Constraint Definition
— 1 comment
wrote 3 months ago: I have to get the definition for multiple default constraints on a SQL database I look after. To do … more →
SSMS Tools Pack
wrote 3 months ago: SQL Server Management Studio (SSMS) has some good functionality but there’s still some things … more →
SQL Split String Function without using loops
— 1 comment
wrote 3 months ago: One of the many omissions from SQL is a split function. This nice little function from stackoverflow … more →
SQL Return Query Results as HTML Table
wrote 3 months ago: I recently had the need to return some data in HTML format and the best way of doing this way to ret … more →
SQL Get Object Definition
— 1 comment
wrote 4 months ago: There are several methods (sp_help and object_definition) for getting definitions for stored procedu … more →
Microsoft Infrastructure Planning and Design guides
wrote 4 months ago: Whilst searching for a SQL Infrastructure Planning and Design (IPD) guide I stumbled across this lin … more →
SQL Find Missing Indexes
wrote 4 months ago: It can’t be overstated the importance of using indexes on databases over a trivial size. But i … more →
SQL Split Function
wrote 4 months ago: It is somewhat baffling that such a widely used function as split is missing from T-SQL. Perhaps not … more →
SQL Sentence Case Function without Loop
wrote 4 months ago: I am not a fan of using loops in my SQL queries. So, finding this rather elegant solution to convert … more →
