Viewing 15 posts - 646 through 660 (of 2,463 total)
Is this a existing exec plan OR you created new one ?
December 26, 2012 at 12:31 am
jitendra.padhiyar (12/24/2012)
December 26, 2012 at 12:10 am
vinu512 (12/24/2012)
Select Char(34) + Char(67) + Char(72) + Char(69) + Char(69) + Char(82) + Char(83)+ ' ' + Char(68) + Char(87) + Char(65) + Char(73) + Char(78)...
December 26, 2012 at 12:04 am
Nidhi G (12/24/2012)
How do I delete one entry then?
this query will help you to remove duplicates
delete t from
(
select ROW_NUMBER() over (partition by Id order by Id...
December 26, 2012 at 12:00 am
December 25, 2012 at 11:43 pm
Eric M Russell (12/25/2012)
December 25, 2012 at 11:07 pm
zi (12/23/2012)
Kindly,what should I do to know this percentetge for the Database not for a certain table ?
this is used for index maintenance. need for details .... we need...
December 23, 2012 at 9:55 am
sqlsurfer11 (12/23/2012)
Do I drop the indexes and the primary key and then insert data and add them back? .
see i am not in favour of diasble the index (clus...
December 23, 2012 at 8:41 am
SQLSACT (12/18/2012)
I have confirmed with the App team that it is to be expected for this time and I can expect even more growth
if this is expected and confirmed...
December 21, 2012 at 3:32 am
GilaMonster (12/21/2012)
What does the error message say you are missing?
what i can get from error is testtable_archive data is "falling out of range" from partition 1 but...
December 21, 2012 at 1:48 am
chewychewy (12/21/2012)
I don't understand this. since i specify mssql_agent and mssql_engine as service account, why doesn't the 2 have sysadmin privileges?
What i can understand here is that u...
December 21, 2012 at 1:36 am
RK2012 (12/21/2012)
Shall i create temp tables in production ?
What kind of ?
physical user table which you are going to use to store data temporaraliy?
or #tmp or ##tmp...
December 21, 2012 at 1:28 am
GilaMonster (12/21/2012)
That's what your partition function says.
what steps i followed .
1 I creaed a table TestTable_Archive (NOn partitioned table )
2) then i moved data from testtable by...
December 21, 2012 at 1:25 am
Bhuvnesh (12/20/2012)
Sean Lange (12/20/2012)
pr.price <> 9999.99
Try making this a SARGable predicate by removing the <> and replacing with > OR <
pr.price < 9999.99 OR pr.price > 9999.99
new learning for...
December 20, 2012 at 11:58 pm
GilaMonster (12/20/2012)
You specified the partition ranges yourself.CREATE PARTITION FUNCTION PartitionDB_PartitionRange (INT)
AS RANGE LEFT FOR VALUES (500,1000,2500);
So here partition 1 means "Less than 500" ?
December 20, 2012 at 10:56 pm
Viewing 15 posts - 646 through 660 (of 2,463 total)