Viewing 15 posts - 2,266 through 2,280 (of 3,008 total)
It’s not arrogant if you can back it up.
However, there are plenty of people that are arrogant that can’t back it up. An arrogant attitude is often a cover...
July 21, 2008 at 11:27 am
As for why it excludes the trailing spaces, who knows? It is working as documented in SQL Server Books Online:
"Returns the number of characters, rather than the number of...
July 17, 2008 at 8:51 am
The thing that no one ever asks (or answers) when a system is being implemented is “How long do we keep the data?” If you do get an answer,...
July 16, 2008 at 1:16 pm
You might find a data model here that you can use or adapt to your needs:
July 16, 2008 at 12:28 pm
This is a good article on how to avoid SQL Injection, even if you do not use stored procedures.
Always Use Parameters. Even if you don't use Stored Procedures.
http://weblogs.sqlteam.com/jeffs/archive/2006/07/21/10728.aspx
July 16, 2008 at 12:12 pm
This script will give you what you want with SQL Server 7.0, 2000, or 2005. It gets the file information for every database on a server, and gives various...
July 16, 2008 at 10:03 am
maximation (7/15/2008)
1.2.
That's really quite common. It's nothing to worry about.
July 15, 2008 at 11:58 am
Set the database offline before you start the restore. That will prevent users from connecting to it.
use master
alter database MyDatabase set offline with rollback immediate
restore database MyDatabase...
July 15, 2008 at 9:29 am
You might find that it performs better if the server has multiple CPUs. I doubt that it will perform worse.
I would be more concerned about the hosting company. ...
July 15, 2008 at 9:22 am
It is really a dynamic process. You need to look at a number of metrics to understand what is happening.
[SQLServer:Buffer Manager][Page life expectancy]
[SQLServer:Buffer Manager][Page lookups/sec]
[SQLServer:Buffer Manager][Page reads/sec]
[SQLServer:Buffer Manager][Page writes/sec]
It...
July 15, 2008 at 9:11 am
Are you asking how to backup a SQL Server or Exchange Server?
July 15, 2008 at 8:29 am
You can use the free SQLPing 3.0 utility available on the link below to find SQL Server instances on one or more servers.
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
July 15, 2008 at 8:25 am
Not to mention that people will be able to wrongly post their SQL 2000 questions of both the 2005 and 2008 SQL forums.
July 11, 2008 at 3:28 pm
They didn't really announce that they are releasing SQL Server 2008. They announced that they are adding it to the price list.
July 11, 2008 at 11:47 am
Viewing 15 posts - 2,266 through 2,280 (of 3,008 total)