Viewing 15 posts - 5,026 through 5,040 (of 7,168 total)
This question has come up before and IIRC .NET FW is not listed as a requirement for the product itself. It is required for the installer, however once installed it...
November 18, 2011 at 11:34 am
Some items imposed on us by third-party apps that have caused trouble:
1. Is your application able to connect to a named instance?
2. What are your network protocol requirements? TCP/IP, Named...
November 18, 2011 at 11:16 am
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...
November 17, 2011 at 1:23 pm
##################################################################################
$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...
November 15, 2011 at 1:21 pm
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.
November 15, 2011 at 8:43 am
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...
November 14, 2011 at 1:55 pm
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
November 10, 2011 at 10:17 pm
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...
November 7, 2011 at 10:34 pm
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...
November 7, 2011 at 10:09 pm
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...
November 7, 2011 at 1:27 pm
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....
November 4, 2011 at 6:54 pm
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...
November 4, 2011 at 10:07 am
ulisseslourenco (11/1/2011)
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...
November 4, 2011 at 9:38 am
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)
{
...
November 3, 2011 at 3:01 pm
Viewing 15 posts - 5,026 through 5,040 (of 7,168 total)