Viewing 15 posts - 7,081 through 7,095 (of 7,165 total)
Please post the DDL for your table and the DML for your data.
February 28, 2011 at 2:37 pm
You were asking about different approaches...a denormalized table approach is what you described in the hypothetical table in your original post. Implementing a star schema is an alternative to that....
February 28, 2011 at 2:12 pm
This should work fine...it may just be a situation where the change has not propagated to all domain controllers, specifically one being actively used by your SQL Server instance for...
February 28, 2011 at 2:06 pm
Setting up a server-side trace is the first thing that comes to mind. Trace will allow you to capture the activities for a specific set of logins at a very...
February 28, 2011 at 1:26 pm
PS check out the -b option of sqlcmd...it may be useful in this context if you are not handling errors within your script and do want sqlcmd to set the...
February 28, 2011 at 12:54 pm
ALZDBA,
I could see using xp_cmdshell to avoid pushing a 1GB file across the wire. I do agree with you however that sqlcmd would be preferable over osql.
mailtosaravanan.m,
xp_cmdshell may not...
February 28, 2011 at 12:49 pm
Here is an interesting post regarding the use of ExDAV from ASP.NET:
http://blogs.technet.com/b/kclemson/archive/2004/01/23/62247.aspx?PageIndex=2
There is no code sample for reading contacts but it might be worth a look.
February 26, 2011 at 4:42 pm
Whatever or whoever is kicking off your SSIS package will be forced to authenticate to that network location.
Can you tell us more about the execution context? Is it a...
February 25, 2011 at 1:55 pm
I agree with that is is an "odd" choice. Setting up and maintaining replication in one environment may not be too bad...but throw in the portability issue and you multiply...
February 25, 2011 at 1:38 pm
File extensions exist to let the viewer of the file name as well as to tip off the operating system as to what the program to use to open the...
February 25, 2011 at 12:44 pm
Sorry for the hasty reply initially...
Some options are to run SQL Server Express Edition on your Exchange server so you can use ExOLEDB locally. This could let you bridge to/from...
February 25, 2011 at 12:10 pm
Lookup Linked Servers for your version of Exchange. There is a provider for 2003.
February 25, 2011 at 11:46 am
That's pretty cool Wayne...that's why I wanted "in" on this post. Running an estimated execution plan with the sub-query method using MAX()/OVER PARTITION BY and the CTE (common table expression)...
February 25, 2011 at 11:23 am
GSquared already mentioned it in a previous post:
GSquared (2/24/2011)
February 25, 2011 at 11:13 am
SQLkiwi (2/24/2011)
e90fleet (2/24/2011)
February 25, 2011 at 10:05 am
Viewing 15 posts - 7,081 through 7,095 (of 7,165 total)