Viewing 15 posts - 256 through 270 (of 285 total)
Appreciate any thoughts!!!
January 17, 2011 at 11:44 am
Can I look at the DMV for Page splits. Plz?
January 17, 2011 at 8:29 am
Hi Gail,
Querying DMV, sys.dm db index operational stats, I can see some leaf allocation count and non leaf allocation count for these primary keys. In most...
January 17, 2011 at 7:32 am
Clustered index would not be null at all in my case. However, one point in my mind is that at the intermediate level due to page splits on clustered index...
January 17, 2011 at 6:54 am
Hi Gail, Thanks for your comments.
Still, am not clear on certain point:
The data type is BIGINT for both columns. The cluster index data will undergo many operations like insert,delete...
January 17, 2011 at 5:54 am
I have gone through the first link and understood that we should not go for master, tempdb etc. However, if we are seeing some issues on these databases, how do...
January 10, 2011 at 9:19 pm
Those are exactly same. It does not matter, whether its * or 1 in the case of Exists.
January 10, 2011 at 9:55 am
In order to audit for members of the sysadmin fixed server role, we will need to use two system views: sys.server_role_members and sys.server_principals.
SELECT sp.principal_id
FROM sys.server_role_members srm
INNER JOIN sys.server_principals sp
...
December 28, 2010 at 5:59 am
Its a command line execution method only.
Create a batch file.
Place the statements correctly with correct server name.
Place Go in between the commands.
If am not answering your question, write in...
December 28, 2010 at 5:10 am
I do confirm the load (data) is similar for both test. The only one thing I need to confirm the TRIM functional support on the SSD. Am gona ask my...
December 28, 2010 at 3:54 am
Thanks for your reply and herewith the details you asked and some more clarification.
My testing environment is Windows2008 R2 only.
However, the production is Windows2008 Entp64Bit. Would TRIM support on...
December 27, 2010 at 9:36 pm
exec master.dbo.xp_cmdshell 'osql -E -Sserver1 -i c:\temp\<filename>.sql'
Make sure the following too:
EXEC sp_configure 'xp_cmdshell', 1
RECONFIGURE
GO
December 27, 2010 at 9:17 pm
I totally disagree that the question should have a compatibility also. I have SQL server 2008 with compatibility with 8.:-)
December 27, 2010 at 4:22 am
Hi, found something very useful in the below link. Excellent job !!!
http://feodorgeorgiev.com/blog/2010/07/how-to-query-the-cached-plans-xml/
December 22, 2010 at 2:34 am
Viewing 15 posts - 256 through 270 (of 285 total)