Viewing 15 posts - 2,911 through 2,925 (of 7,168 total)
Just because you slap a .xls extension onto a file does not make it an Excel-format file. What you have is a CSV (Comma-Separated Value) file saved with a .xls...
October 10, 2012 at 5:04 am
As was stated all queries have an Execution Plan. Generating an Estimated Execution Plan for a query is one of the steps the Database Engine must do for all queries....
October 10, 2012 at 4:57 am
mister.magoo (10/9/2012)
Obviously, you must ensure the web site has only ASP.NET Impersonation and Windows Authentication enabled in the "Authentication" settings for this to work...
You do make it seem simple, but...
October 9, 2012 at 4:34 pm
JimS-Indy (10/9/2012)
I see. Any resources on how to verify the user is in an AD group?
.NET System.DirectoryServices.AccountManagement Namespace
I'm also really confused about App pools. Any resources on those? They look...
October 9, 2012 at 10:59 am
You're very welcome. Happy to assist!
October 9, 2012 at 10:48 am
JimS-Indy (10/9/2012)
October 9, 2012 at 10:40 am
Query that checks for LOB columns:
SELECT t.name AS ,
c.name AS [column],
c.system_type_id,
...
October 9, 2012 at 7:01 am
Appropriate for all? No. Pick a spot, maybe 90, monitor fragmentation, and adjust up or down.
I would be careful using a variable length column in a PK, especially if their...
October 9, 2012 at 6:04 am
Yes, and references to the movie that made his flagship car famous:
October 8, 2012 at 10:24 pm
I agree with the advice to use something other than a direct call inside the transaction. Write the data you need to export to a table and then have an...
October 8, 2012 at 10:16 pm
No sense in reinventing the wheel. Even though the servers cannot communicate directly you can still use Log Shipping. You'll just need to automate the copying of the tran log...
October 8, 2012 at 10:04 pm
Not directly. Linked Servers use OLE DB providers only. I did a quick Google session looking for an OLE DB Provider for JDBC but cameup empty.
October 8, 2012 at 9:45 pm
Another reason not to use xp_cmdshell...
Hung connection wait type PREEMPTIVE_OS_PIPEOPS
Consider changing the process to a SQL Agent job that calls your script.
October 8, 2012 at 9:27 pm
lonhanner (10/8/2012)
Will I have a...
October 8, 2012 at 8:37 pm
Viewing 15 posts - 2,911 through 2,925 (of 7,168 total)