Viewing 15 posts - 1 through 15 (of 116 total)
The word "premises" indicates a property (land/buildings).
A "premise" is the basis of an argument or inference.
April 21, 2016 at 9:19 am
Can anybody out there share their experiences communicating with a web-app using SOAP or the SSIS Web Service Task? I'm trying to determine the best practice.
I'm not as concerned with...
February 19, 2015 at 10:14 am
I figured out that I had set the Provider incorrectly for my ADO connection. Starting over -- just opening the package with the one environmental variable configuration set throws a...
May 15, 2012 at 3:52 pm
elham_azizi_62 (6/12/2011)
hello all.I need to access to description of view columns.I know to access description of table columns.please give me one script that show description of columns of views.
SELECT
...
June 14, 2011 at 3:14 pm
"I'm just happy to say that SQLServerCentral.com is not complying and I, for one, am thrilled :)"
But Steve, isn't it about time that SQLServerCentral goes public? 😉
February 16, 2011 at 10:58 am
I think mine works better:
http://www.sqlservercentral.com/scripts/Search/64839/
It hits all databases and includes job steps.
June 21, 2010 at 5:16 pm
...You may need to look at the underlying disks from your Fibre Attached Storage (FAS) to see you they are laid out....
There appear to be 5: C,D,F,G, & H. However,...
June 15, 2010 at 9:40 am
Elliott Whitlow (6/14/2010)
Local drives or SAN?
RAID array? What raid level?
Are the OS drives on seperate disks from the SQL data files?
Are the database log files on seperate...
June 14, 2010 at 4:13 pm
Elliott Whitlow (6/14/2010)
Why don't you tell us about the destination server.
It's a Windows 2003 box using 4 Xeon 3.2GHz chips and 3.75 GB of RAM.
SQL Server 2005:
ProductVersionProductLevel
9.00.3282.00SP2
June 14, 2010 at 3:18 pm
Elliott Whitlow (6/14/2010)
Same server/different server?
How complex is the query used to generate the data?
One of the things I've seen is the source isn't returning rows fast...
June 14, 2010 at 2:23 pm
You should be able to execute your package with the dtexec utility. I usually save mine to SQL server and run the following from a sprock.
EXEC xp_cmdshell 'dtexec /SQL \package_name'
June 14, 2010 at 12:01 pm
I've been a Teradata user over the past year and I've never seen a SQL Server run anywhere near as fast on large data sets. On the other hand, all...
April 22, 2010 at 10:11 am
JJ B (3/23/2010)
I don't think I've heard the term "bridge" table before, and yet without even reading the article, I knew instantly...
March 23, 2010 at 11:22 am
Ed-997158 (3/23/2010)
David Korb (3/23/2010)
Tom Wilson (3/23/2010)
March 23, 2010 at 9:17 am
Tom Wilson (3/23/2010)
March 23, 2010 at 9:03 am
Viewing 15 posts - 1 through 15 (of 116 total)