Viewing 15 posts - 16 through 30 (of 490 total)
No it's not. SQL includes the clustering key in all nonclustered indexes anyway whether you specify it or not
I agreed,but there is no need to mentioned in the nonclustered index,it...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 4, 2011 at 12:07 am
Rebuild Indexes effect when you have page count > 1000,check the page count of the index with the help of
sys.dm_db_index_physical_stats
http://msdn.microsoft.com/en-us/library/ms188917.aspx
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 3, 2011 at 11:24 pm
It's most ironic that you've taken the very same position which you are complaining the most about
another non professional person :w00t:,I didnt say anything about anyone solution here because every...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 3, 2011 at 11:20 pm
@opc.three
thanks and I appreciate
Oh for crying out loud
mentally disorder
Yes I absolutely did read the entire paragraph. Are you telling me that when DBAs write scripts they are not developing...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 11:04 pm
Dont use Clustered index column in the NonClustered index this is overhead and leaf level of this nonclustered index will be same as your index when you will create the...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 10:40 am
Yes, it's bad practice. Sysprocesses is deprecated, it's a compatibility view solely for old code written for SQL 2000
Practice and Recommendation are 2 different things,Here we are providing solution,that is...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 10:32 am
you must have indexes on the columns which those are using in WHERE clause and in joins
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 6:29 am
btw, why do you persist in writing queries against a compatibility view that is deprecated and scheduled for removal. You're teaching people bad practices.
is this bad practice ? what...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 6:18 am
Go for this to EMC or IBM
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 6:16 am
if you have passed the T-sql GRANT SELECT ON TO then he cant access the systems databases and systems objects even other user objects
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 6:12 am
If Code is executed then execute this script
SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST
WHERE STATUS ='SLEEPING'
ORDER BY CPU DESC
if code is executing then execute this script
SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 6:08 am
Did you move from sql server 2005 to sql server 2008 ?
Are you doing routine maintenance of the Server ? if you are doing this whats are the step ?
SELECT...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 5:58 am
Recommended to remove the SysAdmin Role on these type of users in the case of SQL Server mode + Windows Authtication option is enabled
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 5:42 am
For PCs
CREATE TRIGGER [CONNECTION_LIMITED]
ON ALL SERVER WITH EXECUTE AS 'sa'
FOR LOGON
AS
BEGIN
IF (host_name() in('PC201','PC301')
ROLLBACK;
END;
For Combination of PC's name and Application
CREATE TRIGGER [CONNECTION_LIMITED]
ON ALL SERVER WITH EXECUTE AS...
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 5:40 am
Try with this Info
Product Name : Informix
Data Source Name : DSN Name
Catalog : Database Name
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
July 1, 2011 at 5:30 am
Viewing 15 posts - 16 through 30 (of 490 total)