Viewing 15 posts - 511 through 525 (of 700 total)
SQL Server licensing has nothing to do with the number of connections.
It's either per-processor or server + CAL.
Per-processor = unlimited users, devices, and connections.
Server + CAL = Each server must...
February 13, 2007 at 9:16 am
All of the WHERE clauses in the view are unnecessary. The CHECK constraints on your tables take care of everything, provided SQL recognized the view as a partitioned view.
-Eddie
February 9, 2007 at 1:54 pm
Check out the command-line tool RELOG. It allows you to take log files created by Windows SysMon/PerfMon and convert them to different formats, including exporting them to SQL Server databases....
January 25, 2007 at 10:52 am
There are so many changes in the platform and the services that a three-year timeout on the cert is quite valid, and only adds value to the cert. (Upgrade exams...
January 25, 2007 at 12:50 am
I'd just kill the job for a week and see if performance tanked, or other indicators that things were too fragged (i/o's per second steadily increase, i/o-related wait counts and...
January 25, 2007 at 12:35 am
Test systems should at least try to mimic production.
If the database is called 'prod_database' in production, then call it 'prod_database' in test, dev, qa, whatever. Name the server or instances...
January 25, 2007 at 12:15 am
I've spent a lot of time on the phone with MS SQL Server support over the last few weeks. They've sent us some private patches for some bugs we've come...
January 23, 2007 at 12:42 am
The question I would ask first:
Why are you running a huge REINDEX every night?
Unless this is set up so only part of the database gets hit every night, rotating through...
January 23, 2007 at 12:36 am
xp_backup_database takes parameters. Why are you building a string?
EXEC master.dbo.xp_backup_database @database = @p_database,
@filename = @YourFileNameParameter, @threads = @YourThreadsParm....
December 19, 2006 at 12:28 pm
Bill and Mohammed: Wrong and wrong.
The number of concurrent connections is not licensed in any way.
(edit: the following link is no longer good...)
(As of the release of SQL Server...
December 10, 2006 at 1:04 am
The only OS exam for MCDBA is Windows Server; no desktop exam is part of it. The 2000 Pro or XP Pro could be used as an elective, but it's...
December 10, 2006 at 12:53 am
The ISS T-SQL Querying book concentrates on writing efficient queries, the programming book looks at other components of programming - datatypes, xml, etc., etc., etc.
Before digging in to the development...
December 8, 2006 at 7:34 am
> Can anyone tell me how to fix this?
Upgrade to SQL Server 2005 and join the table-valued function using CROSS APPLY or OUTER APPLY.
You must pass a constant (or constant...
November 24, 2006 at 8:07 pm
Predictive queries are the domain of data mining. Analysis Services and DMX are the keys here, not a multiple self-join of a large data set.
As far as digging up a...
November 11, 2006 at 2:29 pm
O.L.A.P. That's what it's all about - aggregating loads of data for this kind of stuff.
Not sure what you're using this for, and OLAP (a.k.a. SQL Server Analysis Services) is...
October 17, 2006 at 10:55 pm
Viewing 15 posts - 511 through 525 (of 700 total)