How to DELETE huge record around (2 Lakhs) from a table very fast.
Feb 23, 2014 · The idea behind batching updates and deletes is to increase concurrency by having SQL Server take a limited number of locks for a short period of time and allowing SQL …
How to retreive next sunday date from present date.
Oct 14, 2010 · I have created report in which i have to show date in one column and in other immediate sunday date from that date.tell me how to do the same in SSAS reports.
How to show show MM/DD/YYYY 12:00:00 AM
Jun 30, 2009 · For SQL query input parameters a string with the required date/time will work. If an input parameter in a SQL query is a DateTime, it seems automtically convert strings correctly. …
MDX to pick the data from first day of the current month
Oct 5, 2010 · The above query returns around 4 years of data, but I need the data from first day of the current month.
Spliting Date into week1, week2, week3.......for every month.
Nov 22, 2011 · First of all, the definition of "week" is a non-trivial matter. Does your week start on Mondays or Sundays? If Oct 1 is on a Saturday, what is week 1? Here is a fairly simple …
Some Dataset fields not available in the Report Designer
Jul 28, 2012 · Within the Report Designer however, the Day2-Day7 columns are not showing as selectable as a formula for a tablix cell. Why on earth are these fields not showing up? Edited …
Slow query after removing 50% of table data
Nov 10, 2017 · Apparently the delete 50% leaves the table in "confusing state" for the database engine optimizer. This is not supposed to happen after REBUILD-ing indexes and updating …
3 digit Julian date - social.msdn.microsoft.com
Sep 30, 2019 · I see several examples of converting Julian Dates, but not a simple one that's escaping me. Can someone provide the formula to convert today to today's 3-digit Julian …
how to design calendar in reporting service.
Jul 24, 2012 · You need to create the “calendar” in database and then use a matrix in the report. Here is the step: 1 Create the “calendar” in database:
Why isn't Resource Governor working as expected?
Nov 7, 2016 · Based on my searching and testing, this is by design, Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption, in your …