Viewing 15 posts - 301 through 315 (of 2,462 total)
Shadab Shah (3/4/2013)
Start with this http://www.red-gate.com/community/books/sql-server-execution-plans
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 3:13 am
See http://msdn.microsoft.com/en-us/library/ms188386.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 3:09 am
winmansoft (3/5/2013)
Its just like using sub query in IN,but i want contains instead.
I aqm not sure what you are asking ? please clarify
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 2:48 am
ESAT ERKEC (3/5/2013)
two...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 1:39 am
Technically any column which is part of any index will get impacted by any DML operation plus statistics also get hit
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 5, 2013 at 1:24 am
Thanks Dwain and lynn 🙂
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 4, 2013 at 1:30 am
bala2 (3/1/2013)
But we are able to connect the databse through SSMS uing the same login and password.
have you tried this on same machine(server) or from other machine(sql client)...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
March 1, 2013 at 3:35 am
-- Get all SQL Statements with "table scan" in cached query plan
;WITH
XMLNAMESPACES
(DEFAULT N'http://schemas.microsoft.com/sqlserver/2004/07/showplan'
...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 4:11 am
Modest DBA (2/21/2013)
One more thing is there any way to make this faster?
Yes and the first step would be tune your stored proc
1 try to restrict the query...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 3:56 am
SQL* (2/21/2013)
How the index will be organized in indexes if the table is partitioned?
i didnt get this question ? please clarify
SQL* (2/21/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 3:46 am
from BOL
Although partitioned indexes can be implemented independently from their base tables, it generally makes sense to design a partitioned table and then create an index on the table....
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 3:34 am
Delete will take time as OPC mentioned above as it has to reference child tables too .
Two approaches are there.
first,
although it is not recommened if you are following...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 12:28 am
i am not a .net guy, you should search in .net forums like codeproject for this .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 12:23 am
Google it 🙂 i am sure it will help you more than anyone else.:-D
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 12:14 am
I think you are talking about pagination here. this can be done at application and sql server both.
search google for "row_number()"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
February 21, 2013 at 12:11 am
Viewing 15 posts - 301 through 315 (of 2,462 total)