Viewing 15 posts - 1,606 through 1,620 (of 2,496 total)
It might be the 'right' answer but it is a bit simplistic.
Looking at the SELECT... If a column is not in the SELECT list or a WHERE predicate it...
September 9, 2008 at 7:07 am
If your queries need to sort and group data they will use space in tempdb. Basically you have 3 choices:
1) Rewrite your queries to avoid the sorting and grouping....
September 9, 2008 at 6:50 am
Your problem is because the syntax in the KB article is wrong.
During the SQL Server 2008 development process, the syntax for setup.exe was changed and all keywords must now start...
September 9, 2008 at 2:51 am
Non-compete clauses are a way for your employer to say you are worth more to the business than the value of your salary. This means we should be looking...
September 9, 2008 at 2:36 am
It is possible to get a good backup of SQL Server databases using block level copy, providing you do all the right things. If you miss something out, you...
September 4, 2008 at 6:14 am
My advise is to use whatever your organisation has the most skills in.
The first preference is to leave it in DB2, as moving it means you are paying...
September 1, 2008 at 3:28 am
I don't think that the question gives enough detail to say that limiting SQL Server memory to 512 MB is the right answer.
If you are trying to tune...
September 1, 2008 at 3:17 am
Heh. No, I am asking: what is the security difference between xp_CmdShell and a CmdExec Job step?
If xp_cmdshell or CmdExec are run by an account with sysadmin authority, they...
August 26, 2008 at 5:09 am
Cath has a good idea... Get the Windows admin folk to rename your login so it uses only upper case characters.
August 26, 2008 at 3:58 am
There are 2 parts in using SQL Server 2008, both of which will take some time getting used to:
* Using the database engine, AS, RS, etc
* Using the client tools
The...
August 19, 2008 at 4:58 am
"Customer Service" ..although there are some companies that DO know how to do this.
August 19, 2008 at 4:52 am
Copy Only backups should not be seen as a 'second class' backup. For large-scale OLTP shops they have an important role to play in maintaining availability. They are...
August 19, 2008 at 4:48 am
Leaving the services as not started is not relevant. The SQL Server install starts and stops the SQL services a number of times. The SP2 install also starts...
August 19, 2008 at 2:43 am
One point from the OP...
SSAS is unable to use Windows PAE, so in 32-bit mode the maximum amount of memory available to SAS is 2GB, unless you have the /3GB...
August 12, 2008 at 7:39 am
Viewing 15 posts - 1,606 through 1,620 (of 2,496 total)