Viewing 15 posts - 5,101 through 5,115 (of 14,953 total)
With (nolock) will give you dirty data. There's no way to query system data like that in that manner. It has to lock the table to find out...
February 7, 2011 at 11:27 am
You're probably better off contacting him directly. He may or may not visit this forum in a timely fashion.
February 7, 2011 at 11:25 am
The error you're getting is "no match during lookup". Have you looked at the data before that step to make sure it's what you think it is? (You...
February 7, 2011 at 11:24 am
Brandie Tarvin (2/7/2011)
February 7, 2011 at 11:22 am
Not in a single command, if that's what you mean. I guess you could probably code a dynamic script to do it, but unless you're planning on doing this...
February 7, 2011 at 11:19 am
I got into being a DBA from a sales and marketing position, but it was an opportunity that knocked, so I really can't give you much guidance there.
I can say,...
February 7, 2011 at 11:17 am
Have you checked the restore tables in msdb on that server?
February 7, 2011 at 10:57 am
Does the one row in the lookup match any of the rows you're using it as a lookup for?
February 7, 2011 at 10:55 am
Trey Staker (2/7/2011)
Threadizens, What are you currently using to run virtual servers on your desktops/laptops?
Microsoft Virtual PC
February 7, 2011 at 10:52 am
When you say "system crashes" do you literally mean the computer shuts down, or something else? (That's what I'm used to thinking of as a "system crash".)
Is it possible...
February 7, 2011 at 8:57 am
Use a CTE and one of the ranking functions to limit the set, then join to that.
;with Phones (Name, Phone, Row) as
(Select Name, Phone, Row_Number() over (Partition by...
February 7, 2011 at 8:52 am
GilaMonster (2/7/2011)
SuperDBA-207096 (2/7/2011)
February 7, 2011 at 8:43 am
nzngh (2/6/2011)
February 7, 2011 at 7:16 am
srikant maurya (2/6/2011)
this may help if you Ignore only first number char from Strselect * from Table where isnumeric(left(column_name,1))=0
Besides not being a sure thing, that will also bypass indexes on...
February 7, 2011 at 7:07 am
Viewing 15 posts - 5,101 through 5,115 (of 14,953 total)