Viewing 15 posts - 13,021 through 13,035 (of 14,953 total)
Here's a list of a few more I'd add:
Choose your RAID carefully. RAID-5 is okay for OLAP, but RAID-1/10/01 is better for OLTP.
Do backups to a different drive than...
July 2, 2008 at 11:49 am
Another one that's oft forgotten is splitting tempdb into multiple files if you have multiple CPUs and can split it across multiple drives.
July 2, 2008 at 11:44 am
On the unrestricted growth thing, I'd say it's more important to predict the size the database should be in 6 month (or some other reasonably long interval), and set it...
July 2, 2008 at 11:43 am
@@version = Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1...
July 2, 2008 at 11:36 am
It looks to me like someone was trying to build some sort of procedural many-to-many system, without understanding how to do that the right way in a relational database.
With some...
July 2, 2008 at 9:57 am
If you actually need it to add up to exactly 100%, you need to have something go through, add it up, find the error amount, spread that over as many...
July 2, 2008 at 9:50 am
I don't, but I also haven't looked for one. Hasn't come up for me.
July 2, 2008 at 9:44 am
You could go with what you've got, and use the input parameter as the group name each time. The recursive CTE that I had in my first post, with...
July 2, 2008 at 9:38 am
I just tried this in my ProofOfConcept database, and it seemed to work as expected:
create table #T (
Org int,
[User] int,
Last_Name nvarchar(1000))
insert into #T
select 463, 476, N'????????????' union all
select 1, 1,...
July 2, 2008 at 8:32 am
Check the Services section of the server's management consol. Make sure the service is being started by a valid account, and is running.
July 2, 2008 at 8:22 am
Have you checked that the regular login you're using exists at both the server and database level in the 2k5 server?
July 2, 2008 at 8:21 am
I must be missing something. All your code does is create some variables and assign some basic values to them. I tried it in Management Studio and it...
July 2, 2008 at 8:19 am
I don't believe there is an option like that. Either create one file that you name, or multiple files that are named based on what they are.
July 2, 2008 at 8:17 am
The reason to avoid the Like operator in that is because it is immensely slower than splitting the list (use a Numbers table for that), and joining to that. ...
July 2, 2008 at 8:14 am
Viewing 15 posts - 13,021 through 13,035 (of 14,953 total)