Viewing 15 posts - 3,556 through 3,570 (of 6,401 total)
Yes you can use the tools of a 32 bit client to talk to a 64 bit server.
Have you tried to ping the server from your VDI, are the nessesary...
October 31, 2012 at 3:15 am
A number of ways to do this.
Create a linked server on 1 of the machines then use a cross server query to pull out the data, something like
select *...
October 31, 2012 at 2:44 am
Which column in sys.sysindexes are you talking about?
Also sys.sysindexes is the SQL 2000 view and is included for backwards compatability, you should be using sys.indexes for 2005 onwards.
October 30, 2012 at 9:20 am
Probably due to you not using an ISO standard for your dates.
Depending on the connection SQL will interpret dates differently, take '09/13/2012' is now in MDY format that works,...
October 30, 2012 at 8:50 am
Based on your original code and if you only ever have parts and labor then the below should work.
Not tested due to not having the DDL of the tables and...
October 30, 2012 at 8:45 am
What do you need the output to be
EquipID Location Cycles DateTimeStamp LaborAmount PartsAmount TotalAmount
JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 2237.5 27791.85 30029.35
EquipID Location Cycles DateTimeStamp TotalAmount
JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 30029.35
October 30, 2012 at 7:42 am
Some other good things to read up on
Poor Performing SQL Part 1 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/
Poor Performing SQL Part 2 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/
Stairway to SQL Server Indexes - http://www.sqlservercentral.com/stairway/72399/
Gail's articles - http://www.sqlservercentral.com/Authors/Articles/Gail_Shaw/148127/ -...
October 30, 2012 at 6:45 am
Performance tuning is a huge topic, is there something specific that is causing the majority of the problems or is it more of a general how do I troubleshoot this...
October 30, 2012 at 6:37 am
Its the beginning of the CTE construct, and acts much like a derived table.
October 30, 2012 at 6:20 am
Wow a whole 43 minutes and a second between bumping the thread. Please remember we are all unpaid volunteers here and post within our spare time, so please be...
October 30, 2012 at 6:03 am
What is the reasoning on using BCP?
But if you have the format file and the data in a csv format, all you need to do is build a BCP command...
October 30, 2012 at 5:26 am
By default when importing from CSV XLS etc the source columns in the excel connection are set to 50 characters, you need to go in and change this to the...
October 30, 2012 at 2:54 am
The error relates to truncation so your trying to insert CHAR(100) into CHAR(50) for example, find the maximum size of the data in the column detailed and then increase the...
October 29, 2012 at 3:58 am
It should run as NT AUTHORITY\NetworkService by default not NT AUTHORITY\LocalService. The two accounts have slightly different permissions.
When the fault happens is there any fault with DNS or AD...
October 4, 2012 at 8:32 am
By default the browser runs under NetworkService so unsure if changing it other may have some adverse effects or not. One to investigate further.
October 4, 2012 at 8:24 am
Viewing 15 posts - 3,556 through 3,570 (of 6,401 total)