SQLQuest29

Forum Replies Created

Viewing 15 posts - 46 through 60 (of 286 total)

RE: Disk Alignment best practice - Help !!

Perry Whittle (7/11/2012)
it's no problem
Apologies, but I meant that still 10% un-clarity is there as referencing this Paper: http://www.emc.com/collateral/hardware/white-papers/h6665-symtrx-microsoft-windows-server-wp.pdf
It states that: (Below Fig 12: Page 27) for Win 2003 servers...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 11, 2012 at 10:56 am

#1511694
RE: Disk Alignment best practice - Help !!

Thanks .. now I am clear on it.
Also, made an edit to my answer
Update:
The whitepaper from EMC also states the same .. (Windows 2003 server)
http://www.emc.com/collateral/hardware/white-papers/h6665-symtrx-microsoft-windows-server-wp.pdf
Page: 27, below fig...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 11, 2012 at 10:29 am

#1511682
RE: Disk Alignment best practice - Help !!

Perry Whittle (7/11/2012)
SQLQuest29 (7/11/2012)
Thanks a lot Perry for the clarification !
Still confused with http://msdn.microsoft.com/en-us/library/dd758814.aspx
Valid Starting Partition Offsets
Because versions of Windows earlier than and including Windows Server 2003 comply with...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 11, 2012 at 9:15 am

#1511620
RE: Disk Alignment best practice - Help !!

Thanks a lot Perry for the clarification !
Still confused with http://msdn.microsoft.com/en-us/library/dd758814.aspx
Valid Starting Partition Offsets
Because versions of Windows earlier than and including Windows Server 2003 comply with the 63 hidden...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

July 11, 2012 at 6:59 am

#1511504
RE: Best Practice for LDF location

rummings (5/14/2012)
I read an article that stated that the .mdf and .ldf should be on different disks. Each time I create a new database, I make sure to adhere to...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 14, 2012 at 2:53 pm

#1487400
RE: Transaction Replication Latency Diagnosis

Very well written and insightful.
Thanks for the article
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 9, 2012 at 7:20 am

#1485034
RE: Stored Procedures Performance

adnan.korkmaz (5/5/2012)
Comments posted to this topic are about the item <A HREF="/scripts/Stored+Procedures/90129/">Stored Procedures Performance</A>
Good script..
This will only work for SQL server 2008 and plus.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

May 7, 2012 at 10:52 am

#1484133
RE: How to add new tables to Transactional Replication.

forsqlserver (4/18/2012)
After adding 7 new views on publication side ,Till the time publication is synching with subscriber will my user able to get the data?
You wont be having data only...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 18, 2012 at 1:18 pm

#1475640
RE: Need help with script - powershell and sql agent job

Thanks .. got it !
I was struggling with http://www.sqlservercentral.com/Forums/Topic1282812-1351-1.aspx and did not find any solution.
Is it possible for you to point me in right direction.
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 16, 2012 at 9:57 am

#1474143
RE: Need help with script - powershell and sql agent job

Thanks .. that helped.
how can I make the script to take a user input and enable or disable the job ?
Do I have to use -- read-host for any...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

April 16, 2012 at 8:37 am

#1474068
RE: Select,Update,Delete,Insert etc.. in many server using 1 query

why not use POSH (Powershell) ?
easy, convenient and efficient 😀
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 28, 2012 at 8:11 am

#1465701
RE: Trage Flag info

Simha24 (3/26/2012)
SQL Server sends a new query notification to the application, SQL server can’t find the remote service.
Following errors are getting logged in application log. beacause of any loggings...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 26, 2012 at 8:47 am

#1464308
RE: lots of CXPACKET wait types

Matthew Darwin (3/15/2012)
Well as soon as you alter the collation, you're changing the sort order from the way in which the index is currently sorted, and so you will no...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 15, 2012 at 1:10 pm

#1460106
RE: lots of CXPACKET wait types

Matthew Darwin (3/15/2012)
Well as soon as you alter the collation, you're changing the sort order from the way in which the index is currently sorted, and so you will no...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 15, 2012 at 1:10 pm

#1460105
RE: lots of CXPACKET wait types

Matthew Darwin (3/15/2012)
The problem looks to be the predicate for your scan is using CONVERT_IMPLICIT for your dealer_id and account_no.
I'm guessing this is being caused by the difference in collation...
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

March 15, 2012 at 12:22 pm

#1460084

Viewing 15 posts - 46 through 60 (of 286 total)