From a normalization perspective you are justified in using either model. Use whichever model will provide the easiest path for your development and will meet your performance requirements. The view...

##################################################################################

$recLength = 100 # Dts.Variables("intRecLen")

$inFile = "C:\inputfile.txt" # Dts.Variables("strSrcFileName")

$outFile = "C:\outputfile.txt" # Dts.Variables("strSrcFile")

##################################################################################

# delete existing file if it exists

Remove-Item -Path $outFile -ErrorAction SilentlyContinue

# iterate over input file and write padded...

Impedance mismatch...there is no right answer. Do whatever is easiest for you to code and maintain, and performs well enough to meet your SLA.

I would recommend you create a stored procedure that returns the data you want, sign it with a certificate so it can operate with elevated permissions and then grant your...

Please read this article and follow its recommendations for setting max memory.

http://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/%5B/url%5D

How to: Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard

You can also upgrade them by opening them in BIDS 2008 or Visual Studio 2008.

If you have a ton...

I am not sure about osql.exe as that tool has been deprecated since the release of SQL Server 2005 in favor of sqlcmd.exe. You can install bcp.exe and the Native...

From here: http://technet.microsoft.com/en-us/library/ms189586.aspx

- Transparent Data Encryption (TDE) must use a symmetric key called the database encryption key which is protected by either a certificate protected by the database master key...

I had not, but i just looked it up and it appears it will handle the requirement you have to "centrally manage the keys". At least according to the brochure....

I am wondering if the person who originally granted the SELECT permission on that table explicitly specified the columns in their GRANT statement. This would explain why columns added to...

ulisseslourenco (11/1/2011)

---

Hi guys

There is an application in my company which imports files inside several tables on database. However when there are simultaneous files, a lot of them import registers out...

blah...

Why the trap?

foreach($HOSTNAME IN GET-CONTENT "C:\@\SQL_Scripts\DBA\SQL Server\PowerShell\Servers.txt")

{

$status=get-wmiobject win32_pingstatus -Filter "Address='$hostname' "

if($status.statuscode -eq 0)

{

...

ALZDBA (11/1/2011)

---

Just a way to import your default trace and query it... see attachment

( this one reports auto grow events ,should be peace of cake to have it filter detach...

Elliott Whitlow (11/2/2011)

---

I would probably handle the starting of the job as a Service Broker task. It separates the initiator from the executor very cleanly. It also means...