Viewing 15 posts - 256 through 270 (of 411 total)
To call a stored proc, SQL Server requires a certain 'syntax' when passing in the parameters. And by using the function inline like that, the parser is unable to...
April 25, 2011 at 1:40 pm
Hmmm. There are a few things troubling.
First, a datetime data type holds both the date and the time together. I can see why you may have made your...
April 25, 2011 at 1:35 pm
GilaMonster (4/25/2011)
Yesterday I was getting notifications 10 hours late.
That's probably because since you are so far away; it takes longer for the electrons to get there. They only travel...
April 25, 2011 at 1:13 pm
pooyan_pdm (4/25/2011)
There was a Network related problem.
You are welcome. I'm glad you found it.
Jim
April 25, 2011 at 7:53 am
T1 is quite large to drag over the network. In fact T2 is also, and you never mentioned how large T3 is. What is more, you didn't...
April 23, 2011 at 4:11 pm
What? I didn't know that. Man, after all these years, I think I need to read a modern Windows manual once again.
Thanks for the tip!
Jim
April 22, 2011 at 9:50 pm
Agreed. Devs in production can lead to issues, if not now, later when the team grows or changes.
The reason you want them to not even read is probably because...
April 22, 2011 at 11:21 am
Yes, of course. Good catch. I'll edit my post to correct that.
Jim
April 21, 2011 at 5:00 pm
You mention both SQL Mail and DBMail, which are both very different technologies. My bet is that you are only using one of them. It is recommended that...
April 21, 2011 at 4:25 pm
Ah, that's a bit different then. if it's been working, then I would next check perfmon and calculate the network IO on BOTH boxes. It is possible that the...
April 21, 2011 at 1:37 pm
OLEDB wait's are the appropriate wait for linked activity; basically, SQL Server is waiting on the remote server to return the values. Could be a network bottleneck (or remote...
April 21, 2011 at 9:57 am
shen-dest (4/21/2011)
a query like select * from table_name where column='20110101' scans all table.
In the Query Exec plan, is there a difference between the estimated row count...
April 21, 2011 at 9:37 am
Steve,
Although flights arn't always smooth, we appreciate your willingness, and in fact, your good attitude when things don't go quite right. It's a nice example for us all to model.
SQLSaturday...
April 20, 2011 at 11:43 pm
Ya, no problem. SQL2000's Query Analyzer can connect directly to a 2005 instance. In your case, since you need data from both instances, you can create a Linked Server from...
April 14, 2011 at 7:40 am
Service Packs definately fix many issues, but also potentially alter the behavior of SQL Server too. They can include adjustment to how the Query Optimizer decides how to get...
April 13, 2011 at 5:51 pm
Viewing 15 posts - 256 through 270 (of 411 total)