Viewing 15 posts - 4,951 through 4,965 (of 7,168 total)
There are a few people that come to mind who spend a lot of time on this site that could walk you through solving this in a way that will...
February 29, 2012 at 7:14 am
Storing spectrometer data with 1024 channels is a problem in SQL Server unless you pivot (which has too much baggage to be useful at that scale IMO) since the storage...
February 28, 2012 at 12:02 pm
JQAllen (2/28/2012)
PRIMARY KEY CLUSTERED (requisitionID ASC, parentRequisitionId ASC))
The PK above means that AB and BA cannot both be records in that table.
Ummm, maybe logically speaking, but not in terms of...
February 28, 2012 at 10:43 am
JQAllen (2/28/2012)
In the first part of your post it sounds like you want to implement a simple recursive relationship, i.e., parent-child.
CREATE TABLE [Relation](
requisitionID [int] NOT NULL,
parentRequisitionId [int] NOT NULL,
CONSTRAINT [PK_Relation]
PRIMARY...
February 28, 2012 at 10:36 am
Some possible options:
- If you're just reading base tables in msdb in the dbo schema and not catalog or system views then can you create a stored procedure in msdb...
February 28, 2012 at 9:10 am
Regarding the use of TDE in general, there will be a performance hit for CPU so plan on it...and if you;re leveraging native backup compression to keep your backup sizes...
February 28, 2012 at 9:04 am
If you're serious about protecting "at rest" data in all scenarios including protecting the mdf and ldf should someone get access to the server's file system then TDE is the...
February 28, 2012 at 8:59 am
If you're accessing data using the table name then you have the option of renaming the table and replacing it with a view of the same name with the interface...
February 27, 2012 at 2:54 pm
If all you need to do is execute a package then a single-line PowerShell script that calls dtexec.exe is all you need. e.g.
dtexec.exe /f "C:\UpsertData.dtsx"
See section "dtexec (SSIS Tool): Examples"...
February 22, 2012 at 10:04 pm
sudhirnune (2/21/2012)
my challenge is : I need to find out the Windows Group to which the User Who Logged in belong to.
All groups they belong to or the specific one...
February 22, 2012 at 10:26 am
Why are you trying to use PowerShell to execute SSIS packages? Why not use SQL Server Agent?
February 22, 2012 at 10:23 am
ducvancong (2/19/2012)
I create application role and grant all permission in database for it . but , when I want create new login and user in my application,...
February 21, 2012 at 8:26 am
Jeff Moden (2/19/2012)
February 19, 2012 at 12:23 pm
Jeff Moden (2/18/2012)
opc.three (2/18/2012)
February 18, 2012 at 6:33 pm
TeraByteMe (2/18/2012)
Sorry about the name confusion :-S. I must say that both the solutions (PowerShell & T-SQL) are very elegantly done.
You are correct about each code solution's elegance, for...
February 18, 2012 at 6:30 pm
Viewing 15 posts - 4,951 through 4,965 (of 7,168 total)