Viewing 15 posts - 1,831 through 1,845 (of 2,462 total)
Not all people ( including me ) can understand exec paln iin any format (here xlsm format) . i found it all impossible to read it. so always try to...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 11:40 pm
eseosaoregie (4/21/2010)
--Add Computed Column
ALTER TABLE MyTable
ADD comp_column AS substring(LineRead,2,4) varchar
--Create Column
CREATE INDEX IX_COMPColumn...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 8:53 am
eseosaoregie (4/21/2010)
If i add the computed colum presumably the index to create is a non clustered index?
yes it should be non clus. index
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 7:47 am
teutales (4/21/2010)
EXEC ('USE databasename; CREATE SCHEMA common') AT [127.0.0.1]
Isn't it working fine ?
teutales (4/21/2010)
Edit: a way to solve my problem is to change the default database...
i think...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 7:45 am
Better way would be; test or analyze everything at test server/environment; set your benchmarks then hit the production
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 7:41 am
Better way would be , create a DTS package and schedule it.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 7:38 am
RakeshRSingh (4/21/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 6:48 am
Performance tunning is very VAST area. it will taker years of practice.
You can tune your db thru
1. SQL Server profiler
2. DTA (Database Engine Tuning Advisor)
3. DMVs(Dyanamic management views)
4. DBCC commands
but...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 6:04 am
To implement mirroring across the domain , you need to make domain trustable (using certificates)
see the below links
http://www.mssqltips.com/tip.asp?tip=1705
http://www.codefound.com/implementing-database-mirroring-in-sql-server-2005-across-domains/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 5:57 am
rafa.aborges (4/20/2010)
My question is if...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 21, 2010 at 12:23 am
If you are not satisfied with lowell post.
Please post sampla data with desired output(i got bit confused with your problem).
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 6:13 am
Post your sql query which you are using to export data
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 6:03 am
Ananda-292708 (4/20/2010)
this is such a generic that you could have done 1 hrs easy timepass with them.;-)a whole book can be written on this.
can you post some probable reaons...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 4:46 am
Bhuvnesh (4/20/2010)
Gianluca Sartori (4/20/2010)
(2) Too many indexesHOw indexes put sudden effect on indexes. i am confused with it
i am not sure about your comment but , out dated statistics...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 4:45 am
Gianluca Sartori (4/20/2010)
(2) Too many indexes
HOw indexes put sudden effect on indexes. i am confused with it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
April 20, 2010 at 4:33 am
Viewing 15 posts - 1,831 through 1,845 (of 2,462 total)