Viewing 15 posts - 2,071 through 2,085 (of 2,462 total)
if possible, required ORDER can be set in physical table and then avoid "order by" clause in derived query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 5:06 am
May be you can do/schedule the reindexing in OFF peak hours.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 5:00 am
huston.dunlap (3/16/2010)
Anyone have an idea what might be causing this?
try this
select * from
(Select 'BEGDOC' as BEGDOC
UNION ALL
SELECT 'BEGDOC' FROM table ) t
ORDER BY CASE WHEN t.BEGDOC...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 4:40 am
you can keep prid column with datatype uniqueidentifier.
for definition http://msdn.microsoft.com/en-us/library/ms190215.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 4:12 am
for index size
select
i.name as index_name,
i.[object_id],
i.index_id,
p.partition_number,
p.rows as [#Records],
a.total_pages * 8 as...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 4:06 am
Could you create a new table
with the same definition, and see how it that works?
and I found a post somewhere that suggested uninstalling the
workstation components, repairing the .NET 2.0...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 17, 2010 at 3:45 am
Slick84 (3/15/2010)
A password mismatch?
How ? is somebody resetting it without intimating you ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2010 at 9:01 am
See this
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2010 at 8:59 am
then create login
and i guess you need to map that login to new server
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2010 at 3:18 am
Create a new user on that DB and
use GRANT EXECUTE on dbo.up_SP TO New_USer
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 15, 2010 at 12:44 am
Vicky-854895 (3/12/2010)
set @query =N'SET @importRegisteredData= CURSOR FOR select * FROM OPENDATASOURCE('+''''+@drivers+''''+', '+''''+@path+@filepath+@props+''''+@sheet;
Above lines causing the issue as you can use temp variable under a dynamic Sql.
@importRegisteredData doesnt have scope under...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 7:39 am
How you executing SP at Linked Server.?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 7:03 am
kvtraju (3/12/2010)
Hi everyone iam newbie can you guys suggest me the best handbook on dba administration 2005
Dont forget to read SQL_Server_Execution_Plans by Grant Fritchey, Amazing Book
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 6:45 am
thanks i will read it this weekend
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 6:37 am
thanks i got your point
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 12, 2010 at 2:41 am
Viewing 15 posts - 2,071 through 2,085 (of 2,462 total)