New answers tagged

0

Finally after much R&D and google and code project article whose link posted in question. I had developed a tool to do what was actually needed. Posting a link below. Will be useful for further developers who are needed it badly like me. below is the link: Link to My Github Repo


0

This appears to be standard control-break logic where you want to check to see when the control column (in this case, SalesId) changes and send the email per control column. I've mocked up some demo data in a table variable. This would simulate the data coming out of your complex query. In the sample data, change the string YourEmail@test.com to a real ...


1

Here is an example of how that could be done: --demo setup Declare @Orders table (OrderNumber int, UserLogin varchar(20)) Declare @CustomerOld table (UserLogin varchar(20), UserFullName varchar(30)) Declare @CustomerNew table (UserLogin varchar(20), UserFullName varchar(30)) insert into @Orders (OrderNumber,UserLogin) values(1,'SillySam') insert into @...


1

This is either done using the net start/stop command or by sqlserver.exe command. Let’s first check how it is done via net start/stop command The syntax for a net start/stop command is NET START The service name can be obtained as shown below. Type services.msc in “RUN” window and click OK. This will open the service dialog box. Navigate to the SQL Server ...


1

SQL Server Data Tools (SSDT) has the ability to do just this. It can compare a source and target database, determine the differences between them for many classes of object including tables and executables. It can produce a script to make the target look like the source. You get to choose which changes to include and which to ignore. It is not magic, ...


4

In general, it depends. One case where a CTE is nicer than a derived table is when you need to reference it several times in the query. A silly example: SELECT x,y FROM ( SELECT x,y FROM T WHERE p ) AS A WHERE x = (SELECT MAX(x) FROM T WHERE p) vs WITH CTE (x,y) as ( SELECT x,y FROM T WHERE p ) SELECT x,y FROM CTE WHERE x = (SELECT MAX(x) FROM ...


6

As is, I'd argue that the question isn't answerable. It's impossible to prove a negative and you won't find a guarantee in the product documentation. If you'd like an example of a technical difference between the two approaches, watch a few minutes of Paul White's Query Optimizer Deep Dive session. It is not clear how someone could translate that into a ...


0

If you're basically only making a copy of the database once-per-day, Log Shipping may be less headache to deal with, or you can roll your own solution and just automate daily backup/copy/restores to a secondary database instead - john-eisbrener.


2

The SQL Server Snapshot Agent will use BCP to create an initial snapshot of the data and objects to be replicated. These are stored on disk in the default installation folder. You can specify a different location if you are concerned about space issues in the default location. Once the snapshot has been distributed to the subscribers, subsequent changes ...


0

As answered for JSON_QUERY in this question the same is true for JSON_VALUE as well. Docs on JSON_VALUE In SQL Server 2017 (14.x) and in Azure SQL Database, you can provide a variable as the value of path. Before SQL Server 2017 you would have to build the query dynamically. Examples Printing the query on sql server 2016 declare @id int; set @id = ...


0

Seems you want go for Extended Events configuration using the events query_memory_grant_xxxxx. This is best option for you to log the information and stored out-size SQL Engine which you can read anytime (you can also watch live data), the stored information would not be wiped-out when server restart occurs unlike DMVs Quick setup steps..


Top 50 recent answers are included