Viewing 15 posts - 1,921 through 1,935 (of 2,462 total)
google it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 5:45 am
for statistics i dont know but yes following query help you to figure out which indexes are not being used
select i.name as indexname,
object_name(s.[object_id]) as tablename, s.database_id, s.[object_id], s.User_seeks, last_user_seek,...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 3:54 am
CirquedeSQLeil (4/7/2010)
Bhuvnesh (4/7/2010)
CirquedeSQLeil (4/7/2010)
When do those changes go into effect?well your changes ? as soon steve will look into them and considered them worth 😀
Nah, I was referring to Steve's...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 1:56 am
CirquedeSQLeil (4/7/2010)
When do those changes go into effect?
well your changes ? as soon steve will look into them and considered them worth 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 1:41 am
CirquedeSQLeil (4/7/2010)
SSC Rookie of the Year
this can be used for member who has scored maximum points in one year
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 1:41 am
Be careful when you drop statistics. Doing so may affect the execution plan chosen by the query optimizer.Statistics on indexes cannot be dropped by using DROP STATISTICS. Statistics remain as...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 7, 2010 at 12:10 am
hennie7863 (4/6/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 8:10 am
hennie7863 (4/6/2010)
The company who built the software recommends adding more indexes.
why company asking to add more indexes, did they feel any bad performance in that table? and are all...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 7:53 am
1. Use BULK INSERT method
2. Uss batch approach in DML operations(let says work on 10,0000 records one by one)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 7:26 am
rafa.aborges (4/5/2010)
is there any extra cost? Something that I should be aware of?
* Increases resource usage when modifying data since row versions are maintained in tempDB.
* Update and Delete...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 7:23 am
Jeff Moden (4/6/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 7:08 am
chandrasekaran.ganapathy (4/6/2010)
SELECT * INTO XLImport4 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=C:\test\xltest.xls', [Customers$])
Hi Here Customers$ refers the table name?
try with OPENDATASOURCE
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 4:02 am
Yes, Customer is table
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 3:07 am
we can have more levels after SSCChampion like SSGuru or SSCoach ( for 15000 + or 25000 + points)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 2:10 am
--Excel 2003
SELECT [Folder names],[Names] FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0',
'Data Source=D:\Office\RFP tables outside of RFP.xls;Extended Properties=Excel 8.0')...[sheet$]
--Excel 2007
SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0',
'Data Source=D:\Office\RFP.xls;Extended Properties=Excel 8.0')...[sheet1$]
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 6, 2010 at 1:52 am
Viewing 15 posts - 1,921 through 1,935 (of 2,462 total)