Ninja's_RGR'us

Forum Replies Created

Viewing 15 posts - 5,401 through 5,415 (of 18,926 total)

RE: Performance slow down after stored proc called many times in loop

Elliott Whitlow (6/15/2011)
Well since we are talking about CTE's we are talking about at least what, 2005?
can't remember what version they were introduced in..
CEWII
2k5, same as row_number()

June 15, 2011 at 2:00 pm

#1339304
RE: syntex error

Got your begin / end markers??
Reformatted for my better readability :
If (
Select
Count(*)
...

June 15, 2011 at 1:47 pm

#1339292
RE: Performance slow down after stored proc called many times in loop

BTW what sql version are you on? This can't be 7, 2000 since you have a row_number() in there.

June 15, 2011 at 1:45 pm

#1339291
RE: Performance slow down after stored proc called many times in loop

Elliott Whitlow (6/15/2011)
I got a friendly nudge to come look at this thread and my first impression is this seems like a lot of work to work around a c#...

June 15, 2011 at 1:41 pm

#1339288
RE: Material on SQL server and BI

Google broken?
http://msdn.microsoft.com/en-us/library/ms167593.aspx

June 15, 2011 at 1:35 pm

#1339285
RE: Does ALTER table require DROP/RECREATE of dependent view?

hxkresl (6/15/2011)
Let's say a view is created using "select *" and with no where clause. Is this utterly useless as well as automatically 'updatable'?
Yup.

June 15, 2011 at 1:31 pm

#1339283
RE: sql 2000 - table field with multiple columns

He needs to pivot them into columns, not concatenate them into a single string.

June 15, 2011 at 1:18 pm

#1339269
RE: sql 2000 - table field with multiple columns

Why can't you do it in a matrix?

June 15, 2011 at 1:15 pm

#1339267
RE: Does ALTER table require DROP/RECREATE of dependent view?

Sounds about right.
The query will work if the column exists...
Also a good reason against using select *. Because now everything refferencing can have bugs after the change and you...

June 15, 2011 at 1:14 pm

#1339265
RE: Deleting 4000 different records from a table with where and conditions on each row.

Lowell (6/15/2011)
what's this post counter of which you speak?:-D
Not sure... never heard of it b4 in my life, I swear.

June 15, 2011 at 1:11 pm

#1339263
RE: Performance slow down after stored proc called many times in loop

aracy (6/15/2011)
Ninja's_RGR'us (6/15/2011)
What are you doing with that file one in C#?
You could use SSIS or BCP out to dump that data into a csv or whatever and be done...

June 15, 2011 at 1:10 pm

#1339261
RE: Performance slow down after stored proc called many times in loop

Ya but you just said you can't use temp tables....
It takes a heck of a lot of ressources to insert X million rows into anything.
Select into is likely the fastest...

June 15, 2011 at 1:08 pm

#1339258
RE: Deadlocks Solution

GilaMonster (6/15/2011)
No. Not the pictures of the deadlock graph. There's a hell of a lot of info that's lost in a picture.
The deadlock graphs are files. XML files. I want...

June 15, 2011 at 1:03 pm

#1339252
RE: Deleting 4000 different records from a table with where and conditions on each row.

SQLRNNR (6/15/2011)
Ninja's_RGR'us (6/15/2011)
SQLRNNR (6/15/2011)
You're welcome.
And the posts counter bumps continue!
No wonder you're catching up :hehe:.
He did say "Thanks...everyone"
Ya but you're not "everyone". :hehe:

June 15, 2011 at 1:02 pm

#1339251
RE: Performance slow down after stored proc called many times in loop

What are you doing with that file one in C#?
You could use SSIS or BCP out to dump that data into a csv or whatever and be done in 10...

June 15, 2011 at 1:01 pm

#1339250

Viewing 15 posts - 5,401 through 5,415 (of 18,926 total)