Viewing 15 posts - 1,111 through 1,125 (of 2,462 total)
Another requirement
declare @t table
(
name nvarchar(10),
English int,
Social int
)
insert into @t
select 'John' , 100, 90
union
select 'Mary' , 35, 87
select * from @t
--Output Needed
NOw there column will be 4...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 23, 2011 at 5:57 am
That is running
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 23, 2011 at 5:05 am
Thanks Srikant . i saw your reply today only but i had the same approach yesterday to fulfill the objective.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 23, 2011 at 12:10 am
Thanks Steveb but it means if i have 100 columns i need to do 100 union.That would not be a nice approach
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 22, 2011 at 2:33 am
GilaMonster (1/24/2011)
Why is this query a problem?
the usage of resources if fine as per the query design.but i want to avoid Clus index scan or its cost %. i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2011 at 6:10 am
GilaMonster (1/24/2011)
The msdb job tables are not system tables.
Should i add some required indexes ? and how these table got populated ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 24, 2011 at 5:36 am
sag999 (1/7/2011)
You can also consider Change Tracking or Change Data Capture. Both functionalities come with SQL 2008.
Change data capture is available only on the Enterprise, Developer, and Evaluation editions of...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2011 at 7:03 am
TST1 (1/7/2011)
Msg 1934, Level 16, State 1, Procedure Log_DDL_Database_Events, Line 20
can you post its definition ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2011 at 7:00 am
GSquared (1/6/2011)
I haven't used it in a while (I use CLR procs instead)
i am also using sysadmin credential for xp_cmdshell.
can you help me out how you are using CLR...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 7, 2011 at 6:53 am
Nils Gustav Stråbø (1/6/2011)
You are not by any chance running the reindex maintenance plan between your full backup and differential backup?
maintenance plan just within 1 min interval ..strange for...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2011 at 9:49 pm
yes i always do that but my question is why the results is varying
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 6, 2011 at 5:15 am
can you try to reproduce it ? Size of differential can be only if there is some heavy DML operation within that 1 min interval.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 5, 2011 at 6:32 am
akhandels (12/31/2010)
In SQL Server 2008 management studio, DDL & DML can be scripted using the wizard like this:http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx
This is the fastest way to script DDL and data.
Thank You.
Cracker hint...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2011 at 6:19 am
See if this can help you http://msdn.microsoft.com/en-us/library/cc280663.aspx though i dont have concrete reply for your post
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2011 at 5:46 am
First disable the Foreign keys http://sqlserverpedia.com/blog/transact-sql-t-sql/how-can-i-disable-all-the-foreign-key-constraints-defined-for-a-database/ and do the rest of work
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
January 3, 2011 at 5:07 am
Viewing 15 posts - 1,111 through 1,125 (of 2,462 total)