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 Server to release …
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. If an actual …
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.
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 …
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-minded …
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.
Log_reuse_wait_desc = ACTIVE_TRANSACTION
Jan 27, 2020 · I've a SQL Server 2016 - 130.4411 Standard Edition. I've a database log that keeps filling up (log is 250GB), select log_reuse_wait_desc from sys.databases says that the log can't be reused …
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 date? Thursday, …
SQL SERVER 2016 Setup/Upgrade Error: Client Tools SDK and Client …
Nov 22, 2018 · I tired to Update SQL Server 2014 Enterprise to SQL Server 2016 Enterprise today. All components succeeded except Client Tools SDK and Client Tools Backwards Compatibility.
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: