No announcements
-
0 VotesPOSTING 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 ...
-
1 Votes
RANK Function Over Partition Returns All 1's
Version: SQL Server 2016 SP1 Running the following snippet: USE [tempdb]; GO create table #foo (id int, color varchar(max)) GO insert into #foo ...Answered | 3 Replies | 31 Views | Created by Crazy Adam - 35 minutes ago | Last reply by Crazy Adam - 16 minutes ago -
0 Votes
Fastest way to delete the data from Large Tables
I have around 34 tables which contains 50 million record in every table. Now I have to delete the 20 million records in every table.what is the better approach for this ... -
0 Votes
Select with FOR SYSTEM_TIME ALL clause from a View
How is the result set built under the hood when querying a view with the FOR SYSTEM_TIME ALL clause ? I have several system versioned tables joined in a view and can see more lines being ...Unanswered | 4 Replies | 58 Views | Created by aly13 - 14 hours 29 minutes ago | Last reply by Xi Jin - 1 hour 9 minutes ago -
0 Votes
Help with Testing and finding SQL Server resource Usage
Hi, In our shop we are are actually planning to move to cloud( either PAAS or IAAS) and i was asked to do a load test and find out how much CPU, Memory being used and how much is required in ...Unanswered | 2 Replies | 53 Views | Created by coolguy123SQL - 11 hours 52 minutes ago | Last reply by Will_Kong - 1 hour 56 minutes ago -
0 Votes
Dealing with messy collation and legacy databases
Hi, I just thought I'd post up this bit of code I wrote as it came in really handy dealing with legacy data and databases and getting it into shape. So we had a database where ...Unanswered | 2 Replies | 48 Views | Created by RobFarley - 16 hours 7 minutes ago | Last reply by Xi Jin - 2 hours 8 minutes ago -
0 Votes
calculating date
good day team i need help on a query that will calculate start date and enddate of a meter reading give number of start eg 2 and month of end eg 5, and a querry that calculate ...Proposed | 4 Replies | 71 Views | Created by hapton - 18 hours 2 minutes ago | Last reply by Xi Jin - 2 hours 39 minutes ago -
0 Votes
DBCC SHRINKDATABASE: File ID 1 of database ID 9 was skipped
SQL 2005 CRM Database. Shrink database job fails since last two years with below error . Size of database is growing so fast. Does the listed failure is because of space ... -
1 Votes
Question Query why not group ?
= 0) AND (dbo.TABHDBH.TTTHANHTOANUnanswered | 10 Replies | 202 Views | Created by lamtriendong - Friday, August 18, 2017 7:07 AM | Last reply by lamtriendong - 3 hours 0 minutes ago -
0 Votes
Is there a way to use a conditional where clause
Could someone please tell me, is there a way to do a conditional where clause in TSQL for example: select * from table1 t1 inner join table2 t2 ...Proposed | 3 Replies | 50 Views | Created by Duckkiller53 - 7 hours 6 minutes ago | Last reply by --CELKO-- - 3 hours 44 minutes ago -
0 Votes
convert date to mm/dd/yyyy
hi I have date coming like 2016-01-18 as a date fields I need to store this to different table as ...Proposed | 8 Replies | 71 Views | Created by coool_sweet - 8 hours 44 minutes ago | Last reply by --CELKO-- - 4 hours 2 minutes ago -
0 Votes
ANSI_WARNING Issue
ExceptionManager.ErrorMessage: UPDATE failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes ...Unanswered | 3 Replies | 35 Views | Created by Shishir Sasal - 7 hours 4 minutes ago | Last reply by Erland Sommarskog - 6 hours 19 minutes ago -
0 Votes
ANSI_PADDING Issue
I have different problem with ANSI_padding seting on specific table. I have two databases databaseA and databaseB where I ...Unanswered | 8 Replies | 165 Views | Created by Lakshmi Kiran Reddy Vennapusa - 19 hours 40 minutes ago | Last reply by Erland Sommarskog - 6 hours 24 minutes ago -
0 Votes
how to change dateformate of result grid in sqlserver
hi, I executed following query in adventurework2012 database select * from [dbo].[AWBuildVersion] and found the ...Proposed | 7 Replies | 67 Views | Created by rajemessage - 13 hours 10 minutes ago | Last reply by Carlos Henrique Quadrado - 8 hours 30 minutes ago -
0 Votes
fast way to join on "like" operator sql
0 but it didn't improve much or even i can say it didn't improve at all; so I'm wondering if there is a way faster than the above two ?!Answered | 6 Replies | 10667 Views | Created by Butmah - Saturday, May 25, 2013 6:23 AM | Last reply by mmercad0 - 10 hours 31 minutes ago -
1 Votes
script to dynamically restore all the user databases in SQL server 2008r2
4 -- Exluding system databases -- Opening and fetching next values from sursor OPEN ...Answered | 14 Replies | 291 Views | Created by knewsql - Wednesday, August 09, 2017 6:23 PM | Last reply by KevinBHill - 12 hours 49 minutes ago -
0 Votes
Is there a SQL code refactoring tool available with SQL server 2014 Standard edition?
Is there a T-SQL code refactoring tool available with SQL server 2014 Standard edition? If no what does Microsoft recommend for T-SQL code refactoring ...Proposed | 1 Replies | 51 Views | Created by MLTC - 13 hours 36 minutes ago | Last reply by Dan Guzman - 13 hours 32 minutes ago -
0 Votes
PIvot in Sql
Hi All, Can we not use String function in pivot like below? Select * from ( Select * ...Unanswered | 3 Replies | 65 Views | Created by hingesagar - Tuesday, August 22, 2017 1:01 AM | Last reply by Jingyang Li - 13 hours 36 minutes ago -
0 Votes
Reading tracefiles
Hi TechNet - I figured I would submit a query to this awesome forum before opening a case. This is simple, all my DBAs need to do is read some MSDTC trace files ...Unanswered | 8 Replies | 123 Views | Created by DustinAgain - Monday, August 14, 2017 7:00 PM | Last reply by DustinAgain - 13 hours 46 minutes ago -
1 Votes
Get min values using over partition between two dates?
Hi all ,I have a issue where i need to get two type of min value Min Value 1 = get the min value from the beginning of date until current row's date (I can manage this using over ...Proposed | 2 Replies | 79 Views | Created by Dave_GG - Tuesday, August 22, 2017 3:41 AM | Last reply by Jingyang Li - 13 hours 51 minutes ago -
0 Votes
SQL server 2016, subquery returned more than one value.
= DATEADD(HOUR, -4, GETDATE())) as nowdatetime ,(select MIN(count_id) from Presign_Problem pp2 where pp1.word=pp2.word and nowdatetime >= DATEADD(HOUR, -4, GETDATE()) group by ...Unanswered | 2 Replies | 65 Views | Created by Aleks Roth - 15 hours 36 minutes ago | Last reply by Carlos Henrique Quadrado - 14 hours 37 minutes ago - Items 1 to 20 of 86904 Next ›
No announcements
