Viewing 15 posts - 1 through 15 (of 86 total)
pietlinden (2/27/2015)
you could do it in batches and use a TRY CATCH block for the failure, and write the failed group of...
February 27, 2015 at 12:13 am
Eirikur Eiriksson (2/23/2015)
Quick suggestion, use the sys.sql_expression_dependencies system view😎
SELECTSD.*
FROM sys.sql_expression_dependencies SD
WHERE SD.referenced_database_name IS NOT NULL
;
Great.. works fine
February 23, 2015 at 3:51 am
GilaMonster (2/4/2015)
No, and most used does not mean that it must be indexed. Indexing is a little more complex than that.See the entries on my blog in the indexing category.
Ok....
February 4, 2015 at 3:13 am
Andrew G (1/21/2015)
January 21, 2015 at 11:03 pm
ScottPletcher (12/4/2014)
December 4, 2014 at 10:27 pm
SELECT N.NeedId,N.NeedName,N.ProviderName
FROM dbo.Need N
JOIN dbo.NeedCategory NC
ON...
November 27, 2014 at 6:06 am
Thanks for the info.. its really strong informative..
November 25, 2014 at 5:39 am
kriskumark96 (11/25/2014)
I got a table where i need to add certain rows and minus the valu with a row can any one help in this regard.
I am attaching a...
November 25, 2014 at 1:18 am
Hope this will help,
I just used self join for these kind of approaches.
with cte as
(
selecta.seq as a_seq,a.Name a_name,a.Purchased_date as a_Purchased_date,
b.seq as b_seq,b.Name b_name,b.Purchased_date as b_Purchased_date
from#Temp_data...
October 28, 2014 at 11:07 pm
Koen Verbeeck (9/29/2014)
This can be done with ALTER TABLE or ALTER INDEX.
More info:
September 29, 2014 at 1:29 am
Sean Lange (7/31/2014)
What part(s) don't you understand?
the join part.. how it iterates all the data
FROMEmployee e
INNER JOINDirectReports d
...
July 31, 2014 at 9:37 am
ChrisM@Work (7/24/2014)
DECLARE @t TABLE( ID INT IDENTITY, data VARCHAR(20))
INSERT INTO @t(data) SELECT 'Jacob'
INSERT INTO @t(data) SELECT 'Sebastian'
SELECT * FROM @t
GO
----------------------------------------------------------------------------------------------------
DECLARE @t...
July 25, 2014 at 4:34 am
Luis Cazares (7/24/2014)
I hope that you're using that code for learning purposes only and not instead of REVERSE() function.
yes of course
July 25, 2014 at 4:12 am
Jack Corbett (6/10/2014)
First you have to define what you mean by fast..
If I use my query runs about 3 to 4 hrs
I wanted to minimize the time...
June 11, 2014 at 4:49 am
yuvipoy (5/20/2014)
like 1+4 and so on....
since id 1 is not clear.
for 2 it is like ?
Select 1+4=5
Select 4+2=6
Select 2+4=6
Select...
May 20, 2014 at 4:19 am
Viewing 15 posts - 1 through 15 (of 86 total)