Viewing 15 posts - 1,996 through 2,010 (of 10,144 total)
Brandie Tarvin (10/27/2015)
We have the URLDefense ProofPoint software to prevent bad URL links. But when the site goes down, so does our ability to navigate to the sites in the...
October 27, 2015 at 7:19 am
Ratheesh.K.Nair (10/27/2015)
Was checking an SP execution plan and found an Clustered Index Scan with cost 33% .There were other 2 index seek with cost 33%.
Created a Non Clustered Index...
October 27, 2015 at 5:42 am
Eirikur Eiriksson (10/27/2015)
ChrisM@Work (10/27/2015)
anthony.green (10/27/2015)
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver...
October 27, 2015 at 4:12 am
anthony.green (10/27/2015)
Ed Wagner (10/26/2015)
Lynn Pettis (10/23/2015)
Did some one post an ad somewhere that said we had a surplus of silver spoons? :w00t:
I think we always have silver spoons on hand....
October 27, 2015 at 3:22 am
sql_u (10/27/2015)
The export table, is actually a temp table (contains some data from other joined tables).
What I actually need is to set the seed of identity in my stored procedure.
So...
October 27, 2015 at 3:21 am
BWFC (10/25/2015)
GilaMonster (10/1/2015)
BWFC (10/1/2015)
Hopefully next month there'll be a butty with homemade bacon, homemade sausage and eggs from the allotment on homemade bread. I can taste it already...
So, um,...
October 27, 2015 at 3:11 am
Koen Verbeeck (10/27/2015)
The problem:
I have one database called X. It's the source database for my data warehouse, but...
October 27, 2015 at 2:57 am
sql_u (10/27/2015)
I have 2 tables:
1 is with only one field: numerator
2ed is (for example) sales information.
I need to export (using SP) the sales information with unique numerator per line.
So,
I...
October 27, 2015 at 2:52 am
Alan.B (10/26/2015)
This is a little cleaner:
DECLARE @StartDate DATE...
October 26, 2015 at 10:14 am
nadersam (10/26/2015)
Jayanth_Kurup (10/25/2015)
Hover over the table scan and see the estimated and actual number of rows , that should explain it. Else post the actual sqlplan file.
Thanks Jayanth_Kurup for your...
October 26, 2015 at 4:51 am
rchantler (10/23/2015)
The query produces two different execution plans. If table #hidvals is a heap, the optimizer generates...
October 26, 2015 at 2:37 am
marc.corbeel (10/23/2015)
October 23, 2015 at 9:11 am
robert.sterbal 56890 (10/23/2015)
...I still remember when the church moved the calendar by a couple of weeks - https://en.wikipedia.org/wiki/Gregorian_calendar
Jeff - there's someone older than you on ssc 😉
October 23, 2015 at 8:18 am
Sure no worries.
None of your tables have a clustered index. One of them has a nonclustered index but it's not covering (hence the key lookup). When you find the...
October 23, 2015 at 7:16 am
Viewing 15 posts - 1,996 through 2,010 (of 10,144 total)