Browse by Tags

Lighter side of a TSQL query :: Wedding Style

Published 9 August 8 11:45 AM | SSQA.net

Writing a better TSQL query will get you better performance, in terms of system & life-style too. Here is the email I received from my BIL, too get a lighter side of blending a TSQL query as Stored Procedure (from а BrideGroom) .... guess what would...

Filed under: sql server, procedure, drop, tsql, lighter side

SQL Server Lockdown - Step by Step procedure

Published 13 February 8 2:31 AM | SSQA.net

Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices...

Filed under: sql server, microsoft, security, tools, article, sa, procedure, best practice, downloads, bpa, lock down

Interesting and useful cross-blogs

Published 17 January 8 3:26 AM | SSQA.net

Interesting and usefull cross-blogs from a fellow MVP on stored-procedures, transactional replication: Parse delimited string in a Stored procedure Exporting blank SRS report to excel does not render the headers Setting up Transactional Replication from...

Filed under: sql server, blogs, excel, reporting services, procedure, format, stored

Select columns from (EXEC Procedure_name) - Is this possible?

Published 26 November 7 6:54 AM | SSQA.net

Well.I see many users asking this question in forums. "I have a procedure that returns single resultset. How do I filter the result returned from the procedure? There are, at least, two ways to acheive this Let us create this procedure create procedure...

Filed under: sql server, procedure, openrowset

Reporting Services: Images are not showing properly when deployed on the live server?

Published 30 July 7 6:10 AM | SSQA.net

Normally I wouldn't do much development using Reporting Services, but lately I was trying to play with it to get a flashy type of report for a monitoring information on set of SQL Servers we manage. In this scenario I have developed a report that...

Filed under: dashboard, sql server, developer, error, procedure, images, repoting services

Table schema comparison and sometimes data too!

Published 9 July 7 5:11 AM | SSQA.net

Comparing data and/or schema within your SQL Server environment is a common task when you have to port the data from Development to Production environment. To compare the schema (tables) between the 2 SQL instances is very easy and you can accomplish...

Filed under: sql server, performance, data, red-gate, compare, procedure, compact, pack