Viewing 15 posts - 91 through 105 (of 130 total)
When I used to build this sort of thing I would create a "data" tab that connected to the SQL server and pulled down the dataset. each one on...
June 9, 2011 at 4:29 pm
My initial response is that if you are doing a select distinct on a large table then you are forcing an expensive sort that has probably used a great deal...
June 8, 2011 at 6:14 pm
Transactions are individual items of work in a database. Generally RDMS implementations use transaction support to achieve the ACID principle. That is, every unit of work must be...
June 7, 2011 at 4:55 pm
You're question might have a typo but microsoft has always recommended that TempDB be separate from User databases due to its random IO nature. Transaction logs are sequential write...
May 25, 2011 at 12:15 pm
I have to say that I don't understand the requirement to not allow NULLS in the column but insist that you insert a row without specifying a value for this...
May 11, 2011 at 1:32 pm
I think if you launch mirroring monitor you can reinitialize the snapshot and restart all the agents to get things rolling again.
May 10, 2011 at 5:19 pm
The setup wizard includes a button to send a test email.
May 9, 2011 at 4:22 pm
Unless I am misunderstanding something I believe the answer is yes you can configure SQLMail on your existing SQL 2000 database instance and then configure Database Mail on your SQL...
May 9, 2011 at 1:10 pm
Are the servers on the same domain?
January 6, 2011 at 5:56 pm
It is best practice to create a separate account to run the SQL server service. If you are just creating a new database in an instance then I...
January 6, 2011 at 5:46 pm
Check in the package properties on security. The default protectionlevel is 'EncryptSensitiveWithUserKey'. This encrypts the passwords in the connection managers with a has of your login and machine...
December 14, 2010 at 1:25 pm
Paul Randal has written about this quite a bit.
The recommendation is to move all your tables and indexes to a new partition then delete the old one (shrinking...
December 1, 2010 at 3:55 pm
I don't have any experience with the IPS systems available. Although they probably do a great job of stopping network activity that you can define as bad. I...
December 1, 2010 at 3:41 pm
have you tried setting the registry key:
\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance_name>\SQLServerAgent\MsxEncryptChannelOptions(REG_DWORD)
to '0' or '1'
December 1, 2010 at 1:25 pm
Viewing 15 posts - 91 through 105 (of 130 total)