Viewing 15 posts - 1,096 through 1,110 (of 2,463 total)
brainblower13 (3/3/2011)
I know ,because of Indexed columns , its take long time of execution.
why you think so ?
March 3, 2011 at 5:46 am
Post the query along with table index definitions
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...
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
March 3, 2011 at 5:10 am
Also try to give manual run to that SSIS package
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...
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/
March 3, 2011 at 4:26 am
you can check it as i mentioned in my prior post
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
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...
March 1, 2011 at 6:04 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"
...
February 25, 2011 at 4:25 am
Thanks LutzM , i have read that articles and got the solution .
February 24, 2011 at 10:35 pm
Viewing 15 posts - 1,096 through 1,110 (of 2,463 total)