Viewing 15 posts - 1,096 through 1,110 (of 2,462 total)
brainblower13 (3/3/2011)
I know ,because of Indexed columns , its take long time of execution.
why you think so ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 5:46 am
Post the query along with table index definitions
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 5:26 am
these are the expected stats reason being .when we are calling every records (without any filer/where clause ) definitely Sql optimizer will go for table scan(or i would say clustered...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 5:22 am
no you cannot set any value in global variable.there values are dependent on previous statement's execution status like @@rowcount,@@trancount,@@error etc
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 5:10 am
Also try to give manual run to that SSIS package
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 4:59 am
Dug Fazzani (3/3/2011)
Yesterday our SQL Server (2008 R2) crashed whilst trying to Index a large table.
This stopped people being able to connect to it.
We restarted the SQL and SQL Agent...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 4:58 am
JDBA-eqms (3/3/2011)
hi,How & on what parameters we decide, Which index would be created on a column (Clustered or Non Clustered.)
here is the link which can help you http://sqlinthewild.co.za/index.php/category/sql-server/indexes/
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 3, 2011 at 4:26 am
you can check it as i mentioned in my prior post
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 6:27 am
Sachin Nandanwar (3/1/2011)
Have you set Min and Max Memory settings for each instances ?
No
?Is your box a 64 bit or a 32 bit ?
no
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 6:24 am
Krasavita (2/28/2011)
reserved data index size unused
63456 KB55072 KB7096 KB1288 KB
also I don't see my...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 6:04 am
You can take help of linked server.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 4:58 am
db_owner itself known as database owner.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2011 at 4:41 am
SQLkiwi (2/25/2011)
DECLARE @XML XML
;
SET @XML =
N'<?xml version="1.0" encoding="utf-16"?>
<Report
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 25, 2011 at 4:25 am
Thanks LutzM , i have read that articles and got the solution .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 24, 2011 at 10:35 pm
i got solution for this but this is not nice one 🙁
select * from
(
select
english as [john_english],
social as [john_social]
from @t where name = 'john') a
,
(select english as [Mary_english],
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 24, 2011 at 12:08 am
Viewing 15 posts - 1,096 through 1,110 (of 2,462 total)