|
|
|
|
-
Chintak Chhapia Posted 7 Months ago through Blogs
When we use index query hint, we can give the index number or index name. I use index hint for testing performance purpose only and almost never use it actual code. I tend to use index numbers in test code. But, till some time ago I use to wonder why th...
|
-
Chintak Chhapia Commented 7 Months ago through Ask
Hello Praveen,
You can use expression as below
**WeekNumber:** = DatePart("ww",Fields!date.Value,IIF(year(Fields!date.Value) < 2000,vbMonday,vbSunday))
**WeekStartDate:** =IIF(DatePart("ww",Fields!date.Value,IIF(year(Fields!date.Value) < 2000,...
|
-
Chintak Chhapia Liked 7 Months ago through Blogs
Reseed Identity is behaving differently in New Table and in Existing Table...
|
|
|
|
|
|
|
-
Chintak Chhapia knew 7 Months ago through Just Learned
We all use expressions while working with SSIS and most of us know that SSIS is Case Sensitive in many aspects like for instance, Lookup Operation is Case Sensitive. But do we all know if the text inside the expressions is Case Sensitive?
*@[User::v...
|
-
Chintak Chhapia Commented 8 Months ago through Blogs
Just to add, In SQL 2008 R2 with Standard edition we can take compressed backup.....
|
-
Chintak Chhapia Liked 8 Months ago through Blogs
Storage, although cheap is a limited resource. When working with multiple backups, it becomes essential to backup the databases using compression. Today's post explores how backups can be made smaller by compressing them using native SQL Server function...
|