Viewing 15 posts - 481 through 495 (of 8,416 total)
shilpaprele (5/30/2012)
so how do we monitor/maintain identity jumps sql 2008 R2?
What do you mean exactly? Describe the scenario you are concerned about. There is nothing analogous to identity_gap,...
May 30, 2012 at 4:11 am
There is no equivalent in SQL Server 2008 R2. The cache size for IDENTITY is undocumented and not guaranteed. In SQL Server 2012, it is the CACHE option...
May 30, 2012 at 4:01 am
Very hard to say from the information given. An execution plan with runtime statistics (an 'actual' execution plan) would be very useful, as would definitions for the tables and...
May 30, 2012 at 1:41 am
sqlnaive (5/29/2012)
May 30, 2012 at 1:39 am
You could use a calendar table for this. First two links from a search on "calendar table" using the search box on this page shown below.
May 30, 2012 at 1:31 am
pallavi.unde (5/30/2012)
select top 20 cast(college_id as int)as college_id,substream_name,cast(substream_id as int)as substream_id,[streamgroup_name],cast([course_id] as int)as [course_id],cast([streamgroup_id] as int)as [streamgroup_id],[college_logo],[college_name],[course_name],[universityid],cast([degree_id] as int)as [degree_id],cast(city_id as int) as city_id,[degree_name],[populer_stream],CityName as city_name FROM View_College_Search_Details where course_id=@courseid
Why...
May 30, 2012 at 1:28 am
Revenant (5/29/2012)
L'esprit de l'escalier
Oh I wish I'd thought of that...:w00t:
May 30, 2012 at 12:30 am
opc.three (5/29/2012)
I mean that fragmentation reported in column sys.dm_db_index_physical_stats.avg_fragmentation_in_percent can increase after running ALTER TABLE ... REBUILD.
I suppose it might, it's not something I've ever noticed though. I just...
May 30, 2012 at 12:18 am
The references to oe_po_no and item_no do not have an alias to the outer table, so they are bound to the columns of the table inside the EXISTS clause (alias...
May 29, 2012 at 5:23 pm
sql server developer (5/29/2012)
May 29, 2012 at 5:01 pm
Sean Lange (5/29/2012)
May 29, 2012 at 4:53 pm
opc.three (5/29/2012)
Using ALTER TABLE ... REBUILD can actually make things worse in terms of fragmentation depending on the heap's DDL.
What do you mean?
May 29, 2012 at 3:46 pm
Perry Whittle (5/29/2012)
Were they Windows server MVPs?
No, SQL Server MVPs. The discussion was limited to properly configured x64 SQL Server on large memory systems (where 'properly configured' includes accounting...
May 29, 2012 at 4:13 am
sridhar_kola (5/29/2012)
May 29, 2012 at 4:10 am
This is the first solution that springs to mind. Better ones are surely possible, I'll have another think about it shortly.
DECLARE @Example AS TABLE
(
MID ...
May 29, 2012 at 4:00 am
Viewing 15 posts - 481 through 495 (of 8,416 total)