Viewing 15 posts - 1,801 through 1,815 (of 2,496 total)
Some people suggested buying SQL Developer Edition. If you have the cash, get a TechNet Plus subscript (about USD $350). I have this, and it gives you all...
January 31, 2008 at 4:00 am
You do not have to stay on SQL 2000 just because you need DTS.
If you install SQL 2005 and download and install the DTS Designer component you have a fully...
January 31, 2008 at 3:50 am
First of all, you need to comply with site standards. Many sites classify passwords for service accounts, etc, as Type 1 data (your Security team will tell you...
January 30, 2008 at 4:00 am
Another thing to remember...
The command environment that SQL uses to run commands from xp_cmdshell is not the full CMD environment you get on your desktop.
There is no input stream in...
January 30, 2008 at 3:48 am
Alberto, is there anyone in your office wearing a blue shirt?
When you answer this, do you count all the people who are wearing blue shirts before answering yes or no....
January 30, 2008 at 3:36 am
Take a look at the Oracle site. Sign up for their free magazine, it contains a lot of useful info similar to SQL Server Magazine. Look for Oracle...
January 30, 2008 at 3:27 am
Completely agree with you.
Microsoft do some things well. But they do almost anything but make it easy for their customers to schedule maintenance work. Regular and predictable maintenance...
January 30, 2008 at 3:17 am
Yes, Custom Reports are cool, but you do need SP2.
January 28, 2008 at 9:03 am
You need something to aim for. How about 'Better than the Don' for a score above 28067
January 28, 2008 at 3:08 am
Google 'Taskpad view custom report' - there are a few to choose from. Download what you want and put it in your My Documents\SQL Server Management Studio\Custom Reports folder....
January 28, 2008 at 3:04 am
If you want a fixed port, this can be configured using SQL Server Configuration Manager. Click on Network Configuration then look at 'Protocols for instance-name', right-click on TCP/IP and...
January 28, 2008 at 2:57 am
The minimum build level you should consider is SP2 plus CU1. SP2 fixed many issues but introduced some new bugs that were resolved in CU1.
Now that MS are delivering...
January 28, 2008 at 2:52 am
If you are doing aggregation queries, where the consistency of the result is not critical, you should make NOLOCK your default choice. Also make NOLOCK your default choice when...
January 28, 2008 at 2:44 am
What you want to do looks to be similar to the first step SQL takes when creating a full-text index on a RTF document. When SQL builds a FT...
January 25, 2008 at 3:04 am
All your jobs are stored in msdb, so a backup of msdb will contain all your jobs.
As other people have said, it is a good idea to also have scripts...
January 25, 2008 at 2:52 am
Viewing 15 posts - 1,801 through 1,815 (of 2,496 total)