How to hide Placeholder in SSRS 2008?
Introduction
For the ones who are working with SSRS, Placeholder is not new for them. So, today I will not go...
2012-02-11
8,170 reads
Vinay
Fragmented Index – Rebuild or Reorganize ?
Introduction
In past, many times I have written on Fragmentation of Indexes and how to Defrag them. You can find some...
2012-01-12
15,586 reads
Workarounds for SSRS 2008 Font rendering issue
Problem
A report developed using SSRS 2008 either through Visual Studio 2010 or BIDS 2008 does not renders properly when viewed...
2011-12-02
5,965 reads
Using OFFSET and FETCH
Introduction
Many times while developing our applications we feel the need of pagination, where our User Interface (UI) has to list...
2011-11-30
9,795 reads
How to find out which Table is not having rows in SQL Server?
Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...
2011-10-01
2,314 reads
How to find a string value in all the string columns of a table/view in SQL Server ?
Introduction
I am sure many times we all might have come across situations where we need to search/find a string value...
2011-09-30
6,343 reads
T-SQL to find Fragmented Indexes
Fragmentation of Indexes is one of the reason for low performing queries resulting in a poor application performance.
Today, I will...
2011-08-22
7,514 reads
Lookup functions in SSRS 2008 R2 - III
Introduction
This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup() and LookupSet() have already...
2011-07-30
11,342 reads
Lookup functions in SSRS 2008 R2 - II
Introduction
In my last post on Lookup functions related to SSRS 2008 R2, I had explained Lookup(). It is used to...
2011-07-27
8,549 reads
Lookup functions in SSRS 2008 R2 - I
Introduction
Most of us who are regularly working with SSRS have always felt the need of some way through which multiple...
2011-07-22
35,023 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers