No announcements
-
0 VotesDo you want to be acknowledged as Microsoft Transact-SQL Guru? Join June 2019 competition!
What is TechNet Guru Competition? Each month Microsoft TechNet Wiki council organizes a contest of the best articles posted that month. This is your ...
-
0 Votes
POSTING TIPS - Code, Images, Hyperlinks, Details
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you're asking for ...
-
0 Votes
Sever Agent job with multiple steps
Hi all, For a given Agent job with multiple steps, how can I make sure that step 2 always starts only after step 1 has completed? And step 3 only after step 2 has ...Unanswered | 3 Replies | 79 Views | Created by elsvieta - 13 hours 9 minutes ago | Last reply by Rachel_Wang - 19 minutes ago -
0 Votes
Incremental Stats ON
Hi, Is there any process or script to update "Incremental Statistics property on " on already existint partitioned Tables. When I ...Unanswered | 1 Replies | 44 Views | Created by arc2013 - 7 hours 7 minutes ago | Last reply by Lokesh Vij - 1 hour 25 minutes ago -
0 Votes
Dynamic SQL
The below SQL Code returns all ObjectId's Names with Update Stats. I then have to again manually collect the result set and then run each Update Stats. Is there a way to update stats for all ...Answered | 3 Replies | 54 Views | Created by arc2013 - 5 hours 26 minutes ago | Last reply by arc2013 - 4 hours 56 minutes ago -
0 Votes
How to arrange my quarter data in specific way
i have data stored in table and data look like a which stored in list 1Q 2014A 2Q 2014A 2012FY 1Q ...Unanswered | 2 Replies | 59 Views | Created by Sudip_inn - 8 hours 3 minutes ago | Last reply by Jingyang Li - 5 hours 3 minutes ago -
0 Votes
sp_OAMethod Send FAILED!
I am trying to send SMS using a web api from sql server. I have error in sp_OAMethod. Below written is the code for the same DECLARE @iReq int,@hr ...Proposed | 4 Replies | 2637 Views | Created by testSMdev - Wednesday, April 25, 2018 10:36 AM | Last reply by xXxJoshuaxXx - 8 hours 2 minutes ago -
0 Votes
Removing xlock hint on the select statement with connections having transaction isolation level as snapshot.
We have few SQL statements with Xlock hints and our transaction isolation level is read committed, this xlock is used to restrict/lock same rows not being used by two ...Unanswered | 4 Replies | 166 Views | Created by Sivakumar.In - Friday, June 21, 2019 7:03 PM | Last reply by pituach - 10 hours 0 minutes ago -
0 Votes
Schedule a job which loads data from JSON API in to SQL server table
I am trying to insert data from JSON API(URL) in to a table. I am using T-SQL to achieve it. T-SQL works perfect. Now, When I am using the same T-SQL code to schedule a job, the job ...Unanswered | 14 Replies | 532 Views | Created by Jinal Prajapati - Monday, June 3, 2019 1:12 PM | Last reply by Jingyang Li - 12 hours 0 minutes ago -
0 Votes
SELECT statement raises deadlocks when switching partitions on a table
Hi All, I have a partitioned tables in which i am switching specific partition in and out with in a sql transaction begin tran .. end tran. I run a select ...Answered | 3 Replies | 90 Views | Created by GKS001 - 23 hours 50 minutes ago | Last reply by GKS001 - 12 hours 11 minutes ago -
0 Votes
SUM of COUNTS across multiple tables
Hi, I need to return the sum of counts across multiple tables which have been partitioned. For example, a single partition in the parent table could ...Unanswered | 2 Replies | 68 Views | Created by DapperDev_ - 15 hours 9 minutes ago | Last reply by Jingyang Li - 12 hours 57 minutes ago -
0 Votes
How to identify system jobs in SQL Server
Hello, We have setup always on with two nodes. In order to keep jobs same on both servers- we are looking for scripting out jobs from primary, create those jobs on secondary, first ...Unanswered | 2 Replies | 57 Views | Created by Anil_Kumar_DBA - 16 hours 44 minutes ago | Last reply by elsvieta - 13 hours 12 minutes ago -
0 Votes
Compare two tables with Data using T-SQL
Hello Experts, Before I start, I am only looking for a SQL based solution instead of any other tools as we will not be able to invest in the tools that are out in the market. Also, ...Unanswered | 12 Replies | 460 Views | Created by Bangaaram - Wednesday, June 12, 2019 1:52 PM | Last reply by Bangaaram - 14 hours 2 minutes ago -
3 Votes
Why is my query blocking
Hello All, I have been struggling with this for so long now : Every time I execute this query it goes into blocked state for hours. It ...Proposed | 11 Replies | 368 Views | Created by Pragati Sharma - Tuesday, June 18, 2019 4:07 PM | Last reply by Dan Guzman - 16 hours 7 minutes ago -
0 Votes
Impact to index and statistics by increasing column's lengh in a table
I am planning to increase one column's length in a table by alter query. There are index and stastics already exsited in the table that they refer to the column. My question is after I increase the ...Proposed | 5 Replies | 196 Views | Created by KELLY_IRVINE - Thursday, June 20, 2019 2:20 AM | Last reply by Rachel_Wang - 17 hours 11 minutes ago -
0 Votes
Query via linked server -question
Hi I have the following scenario I am working in SQL Server 1 , Table 1 - Product Table - with ...Unanswered | 7 Replies | 256 Views | Created by John_tay - Friday, June 21, 2019 12:25 AM | Last reply by Ashin_c - 17 hours 23 minutes ago -
0 Votes
SP within SP
Hi, We can write a SP for functionality A, in this SP we can call some other SP for functionality B. Like this way how many SPs we can call? CREATE PROC ...Unanswered | 3 Replies | 50 Views | Created by Pratheeskkvi - 17 hours 57 minutes ago | Last reply by Stefan Hoffmann - 17 hours 53 minutes ago -
1 Votes
tsql help
Hi All, Need some help in preparing a restore cmd dynamically using metadata which is stored inside a table. We need to read the file locations from the ...Unanswered | 5 Replies | 68 Views | Created by Samantha v - 19 hours 20 minutes ago | Last reply by Uri Dimant - 18 hours 15 minutes ago -
0 Votes
Merge with Error Handle
Hi i running following script. DECLARE @count VARCHAR(MAX); BEGIN TRY --select 9/0 MERGE INTO List.ActivityAreas AS TGT USING ...Answered | 4 Replies | 191 Views | Created by Natiq Rzazade - Friday, June 21, 2019 9:09 AM | Last reply by Rachel_Wang - 18 hours 38 minutes ago -
0 Votes
eliminate duplicates query
hi all, please help me with this (simple) query: I have a table with data as follows: id ...Answered | 2 Replies | 153 Views | Created by elsvieta - Friday, June 21, 2019 6:56 PM | Last reply by Sabrina.ZH - 18 hours 43 minutes ago -
2 Votes
looking for query tuning tips
8 Thanks, SamUnanswered | 5 Replies | 221 Views | Created by Samantha v - Saturday, June 22, 2019 9:03 AM | Last reply by Rachel_Wang - 19 hours 53 minutes ago -
0 Votes
Find the Text in a stored procedure
Hello Experts, I need to find the stored procedure's containing UPDATE of just user tables. I have written a script for the same below. It works fine but if the stored procedure ...Unanswered | 6 Replies | 170 Views | Created by Priya Bange - Sunday, June 23, 2019 8:42 AM | Last reply by Rachel_Wang - 20 hours 22 minutes ago - Items 1 to 20 of 93068 Next ›
No announcements
