Koen Verbeeck

Forum Replies Created

Viewing 15 posts - 10,531 through 10,545 (of 11,676 total)

RE: cpu bottleneck

srik780 (1/10/2011)
waht is cpu bottleneck and what will do when it occurs?any one plz
The first hit on Google for the keywords sql server cpu bottleneck:
http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx
A little research won't harm you.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 11, 2011 at 12:51 am

#1271737
RE: Displaying Reporting Services drill-through reports in new browser window

hrishikeshsant (1/10/2011)
How to open a Excel file in Sql Server Reporting Services 2008 R2 through clicking a text box?
You should start a new thread for your question instead of hijacking...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 11, 2011 at 12:48 am

#1271735
RE: Recover the Table Data

Since your database is in full recovery mode, can't you take a tail log backup and do a point-in-time restore right before you deleted the data?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 11, 2011 at 12:43 am

#1271734
RE: ANSI Padding

Good, but difficult question. I had to read quite some BOL pages to get this one right.
And only 1 point?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 11:51 pm

#1271722
RE: Are the posted questions getting worse?

Brandie Tarvin (1/6/2011)
Jack Corbett (1/6/2011)
I also want to encourage all you who are PASS members to opt-in to the session voting for SQLRally. See my this post which has...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 11:39 pm

#1271720
RE: Error changing SQL service account to a domain user account: solved

Thanks for sharing!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 11:06 am

#1271528
RE: Are the posted questions getting worse?

Dave Ballantyne (1/10/2011)
This guy may know 😀
I thought this was a pretty accurate description:
😀 (an oldie but a goodie)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 10:52 am

#1271523
RE: Q: How would I update a table based on changes in an Oracle Linked Server view

At first glance this seems like a situation that the MERGE statement could handle.
http://msdn.microsoft.com/en-us/library/bb510625(v=SQL.100).aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 5:47 am

#1271333
RE: copy of backup files

What have you tried so far? Any issues?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 5:43 am

#1271331
RE: Before Insert or Update Trigger

cengland0 (1/10/2011)
Koen (da-zero) (1/10/2011)
What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there is a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 5:25 am

#1271323
RE: Before Insert or Update Trigger

cengland0 (1/10/2011)
Got this one wrong because I didn't understand the wording of the question.
Is it possible, using a trigger, to update a data row before commiting the insert...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 3:50 am

#1271308
RE: creating dimention table and fact tables

1) Usually you do the design in the database itself, using Management Studio. So you create the tables there and of course, while you create them, you give them names.
2)...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 2:46 am

#1271289
RE: Are the posted questions getting worse?

ALZDBA (1/10/2011)
Indeed, Antwerp was a mess this morning. Slippery roads and unadapted driving style causing "fun" traffic jams all over the place 🙁
Regarding the pastries, I was aiming for the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 2:07 am

#1271280
RE: Are the posted questions getting worse?

ALZDBA (1/10/2011)
Today I'm in Zelzate.
Do you advise any particular bakery for the lovely "lost monday" patisserie ?
Unfortunately I've never been in Zelzate before.
And "lost monday" is particulary popular in...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 10, 2011 at 1:37 am

#1271271
RE: Are the posted questions getting worse?

Tom.Thomson (1/9/2011)
ALZDBA (1/8/2011)
Not feeling tip top today.
I'll have to refrain from xmas tree burning fest and drink :ermm:
:darn:
?? :ermm:
Do you Americans work to 14th night instead of 12th ??
Or...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

January 9, 2011 at 11:49 pm

#1271252

Viewing 15 posts - 10,531 through 10,545 (of 11,676 total)