StartDate and EndDate in same column - I have a date column below RunDate , I want to create two column StartDate and EndDate like this StartDate = '2004-08-01' ...
ToolBox missing for Maintenance task - This morning I logged into SSMS SQL2016 to edit a maintenance plan. I would add a cleanup task. But I noticed...
What happens when delete query executed inside sql server engine , process in deleting file , how data page will be managed , how deleted data pages will be free for next use? - Hi Champs, I want to understand what happens when delete query executed in inside sql server engine , how page de allocation...
Help with date ranges - Hi all, I'd like to know if anyone can help me with a good suggestion on how to achieve this. I have...
Extended Events - sqlserver.query_memory_grant_usage - Hello Folks. Bit of a strange one - or else I am missing something here (high probability). I found some sample code to...
Perfmon does not start for named instance, but does for default instance. - Version in use is SQL Server 2014/SP2 CU5. I have encounted an error that others have also encountered about perfmon counters...
Mirroring in a WSFC environment - We are planning to set up mirroring for a small application db we're installing in our environment. The infrastructure team...
Join on a Substring - I have a proc that runs nightly that moves data into another table. The procedure joins on multiple tables one of...
Trying to speed up this 'GetWorkingDays' function. - I'm trying to redesign one of our working days functions. The idea is to calculate weekends (easy enough) but holidays...
Optimizing Query Using LInked Servers - Hello. Looking at an SP that used to run in a couple of seconds and does something like this : Select X,Y,U...
Where should I save stored procedures and user defined functions for use in all databases? - I have some generic utility stored procedures and user defined functions that I would like to define/save once, and have...
Transport error encountered when SOME queries run with batch terminator. Behaviour changes depending on text of query. WEIRD! - This is one of the weirdest issues I've ever seen. It's so unbelievable that I actually made a video to...
Convert list of columns into quoted, comma delimited list of columns - Summary: I've got a working solution(s). My question is, which is the best approach (if any)? Details: I want to write...
How to find the first recurring character of a string. - I have a query that finds the first recurring character in a string. For eg : if @str = 'ABCCDA' then i...
Substring Question - Hi, I trying to extract the value from a field until a special character eg: firstname.lastname I only want firstname have...
PURGING DATA - HI All, I have an assignment, to Purging data, with conditions: 1. Keep the full data 6 months (keep all the records...
SQL versus program - Hi all, I'm posting my question in this 2008 forum because we're running SQLServer 2008R2, but it is more a general...
What else can take up space in a database besides tables - I have a database that says it's 108 GB USED - I verified with dbcc showfilestats as well as just clicking...
Design considerations for a tabular model - I have a star schema already in existence (SQL Server fact table and numerous dimension tables). For a given tabular...
DDL Triggers and Permissions - Hi, I have created a DDL trigger to fire on the ALTER LOGIN statement. I then want to collect the event...