Viewing 15 posts - 26,191 through 26,205 (of 39,793 total)
Correction noted. It does start with each of us. I was thinking that leaders have to set the example, just as each of us does for our children.
November 26, 2008 at 9:13 am
Also, you can't necessarily control the time to create. If there is something else going on in the host system, a user watching YouTube, for example, things can take longer.
Size...
November 26, 2008 at 9:12 am
The OS matters as well because you might be able to create the 1MB Db as quick as 100MB if zero file initialization is in effect.
November 26, 2008 at 9:11 am
We should measure budgeting like we measure programmers and other employees. By Effectiveness.
Not by making/exceeding the budget. We should look at if money was spent well, needs were met, etc....
November 26, 2008 at 9:09 am
I agree with a lot of what Grant wrote, and while I haven't done this in awhile, the principles are the same.
Labeling releases is crucial to knowing what goes moving...
November 26, 2008 at 9:02 am
Read the daily articles here and on SQLTEam, Database Journal, Simple Talk, etc. and learn. Try answering questions here, pick up a book.
We can help with specific questions if you...
November 26, 2008 at 8:54 am
The same permissions from SQL 2000 exist in SQL 2005.
I'm not sure what you mean by not seeing them. Are you not finding this in SSMS?
Moved to the security forum.
November 26, 2008 at 8:53 am
Quite a few people are running SQL Server is VMs, but you have to be aware that you have less resources than on a similarly sized server. If you have...
November 26, 2008 at 8:52 am
I like Elizabeth's advice, especially about backups. I might put them on the SAN IF I was sure they were on physically separate disks, but you want to make sure...
November 26, 2008 at 8:49 am
Be aware that some subsystems, like SSIS, are not instance aware. They can be installed only once on a particular host server. If SSIS is installed, it's available in all...
November 26, 2008 at 8:46 am
Certain features of SSMS 2008 are turned off with prior versions. Intellisense is one of them. They didn't write anything to figure out which functions/features work with each version, so...
November 26, 2008 at 8:44 am
Do you really need them to execute at the same time or just both execute and return a value before sproc 3?
The technique above from sql_er will work if they...
November 26, 2008 at 8:43 am
The compatibility level affects which keywords are working, so you can't do this without changing the level. However you can use T-SQL, as mentioned above, to achieve the same type...
November 26, 2008 at 8:41 am
Very strange. I might write a routine to capture the sp_configure settings every hour or so and report if it's changed. That will help you narrow things down to see...
November 26, 2008 at 8:40 am
Viewing 15 posts - 26,191 through 26,205 (of 39,793 total)