Viewing 9 posts - 16 through 25 (of 25 total)
Use display execution plans to check for
1) table scans -- which means missing index, bad sql join, or bad where clause criteria.
2) index scans -- it's using an index, but...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 13, 2012 at 8:36 am
http://msdn.microsoft.com/en-US/library/ms189858(v=sql.105).aspx
See link. It's an either by partition or all.
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 13, 2012 at 7:51 am
First step should always be to use explain plan to look for table scans, among other things. That would usually indicate a missing index, a bad join, etc...
You've can...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 12, 2012 at 8:29 am
What is your code page in SSIS flat file connector?
What is your database collation?
I just imported from a csv file the below data into test1 table with fields id int...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
April 5, 2012 at 7:32 am
convert(datetime,convert(char,getdate(),102))
The inner convert removes the time portion. The outer convert brings it back to date
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
March 28, 2012 at 7:32 am
You completed with:
At this point, all passive nodes has the service pack installed and it’s time to perform the update on the active node (serverA), so connect to it and...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
March 21, 2012 at 7:32 am
In order to query two databases, you set up a linked server under 'server objects'
The code is below:
/****** Object: LinkedServer [MyDB\MyInstance] Script Date: 11/11/2011 09:07:21 ******/
EXEC...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
November 11, 2011 at 8:11 am
You can start by 1) adding this to your company table
alter table company
add [account number] as left(companyname,6)
2) Then create the index for it.
3) Change your sql to use...
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
November 7, 2011 at 10:39 am
I have the same problem, but my @@servername is set.
Any other ideas?
*****
Give a man a fish, and you've given him a meal. Teach a man to fish and he'll ask to borrow your boat.:-P
September 17, 2009 at 5:20 pm
Viewing 9 posts - 16 through 25 (of 25 total)