Folks, I am wanting to know what permissions I should grant to my DTS developers in order to let them have all DTS/SSIS related permissions, also can...
I know in sql 2000, in order to grant 'Execute' permission on all sps, functions and etc to a DB role, we have to first create a cursor, and run the...
Can someone provide me some idea on how to call the sql script files, I organized my scripts into smaller SQL files instead of putting everything in...
A stored procedure can be published only as a 'serializable proc exec' article, a 'proc exec' article, or a 'proc schema only' article. Can someone...
Gurus, just want to know what kind of locks was used on log file when backing up the T-log.. What kind of overhead generated for DB system when...
Just curious, where are SSIS / DTS packages are stored?
Guys, please recommend me several good sites for SMO, RMO and WMI programming, thanks.
Why T-Log grows that large during DBCC DBReindex. What kind of activities are logged in the T-Log during the Reindex. thanks.
It is Microsoft SMS (systems management server), we used a 8 procs, 4GB RAM server as central publisher...dedicated distributor...SQL 2K EE with SP4...
Log shipping was set up between 2 SQL Serve 2K EE with SP4 on windows 2K3 servers...We utilized the maintenance plan to setup the log shipping....
I did a migration through backup - restore to new SQL Server 2005 SP2 server.... Customer complained the poor performance after the migration......
Repl Gurus, since this is our PROD environment, I need to be very careful. System topology: SQL 2K EE with SP4 publisher + separate SQL 2K EE...
Do you guys use SQL snapshot in your environment, if yes, for what kind of purposes? Any advantages? ------------------ Bug...
In SQL 2K, user and schema seems the same thing. In SQL 2K5, they are separated. What is the essential difference bewteen these two?...
CREATE VIEW [dbo].[M_CaseMaster] AS SELECT CM.* From CaseMaster CM where CM.EmployeeNo in (select E.EmployeeNo from Employee E,CaseMaster...
SQL 2K EE SP4 on Windows 2k3 servers, here it is the errors found from errorlog when opening by text file. DB services and SQLAgent services are...
Recently, I am troubleshooting a server side cursor performance issue, here is the trace. For an insert operation it took CPU:15, Read:102,Write:18,...
Folks, I need a script to sort all user tables based on the row count and storage size? thank you so much, SQL 2K5 EE ------------------ Bug...
From 2K5 BOL, the unit of duration column is Microsecond, but when I ran a trace, I found in real environment, it is still millisecond like SQL 2K?...
I schedule translog backup every 30 mins, and at 11PM, DBReindex will kick off which takes around 1.5 hours. DBReindex is an offline operation which...
Separate names with a comma.
