vineet_dubey1975 (2/7/2014)

---

I am serving data to the end user(WebPage) via table 'ATABLE'. The data in the table got refreshed after every 1 hr. through a SQL Job (Truncate and refill)...

New Born DBA (2/6/2014)

---

So, what can be done at this point? I don't have any option other than using a Wizard. I don't mind using PowerShell but I am not...

if it went a way after altering the proc, and then came back after a few hours, i'd start suspecting that stale statistics were affecting performance of the existing plans;

if...

wah.... this is the first time i saw this new highlighting and "this worked for the OP";

cute ehnacement!

make step 2 test for a specific time window as part of it's process.

i start a trace @7am if it's not running, and turn it off at 5pm for example:

--###############################################################################################

--startup...

group accounts via SMTP have to be explicitly opened by your exchange administrator, i believe; it's to avoid things like spammers sending to staff@microsoft.com anf getting viagra information to 80K...

the usual answer is it depends on how you are searching;

if you are searching on last name (WHERE LName = 'McArther')

then yes, an index would help a query like that.

anything...

misspoke on "functions", sorry. unfortunately functions don't follow those nifty abilities like procs.

views can be immediately referenced if they start witk sp_, so i have things like sp_Trace02 in my...

ok this might get you started: if you enumerate the permissions for your windows group, and then join this query of active directory for gorup members, you cna get the...

i actually make things system functions , system procedures, and stuff quite a bit i have a ton of developer tools i've created and adapted that go in master.

they all...

this is just a variation on what you posted, butI see the delay is the WHERE Clause, 18 seconds for a server with 62 databases

but i don't have very many...

i think a field with a SUM+CASE statement would do the job:

SUM(CASE WHEN order_date > 2012-01-15 THEN amount ELSE 0 END ) OVER (PARTITION BY customerid )

--this passes 2012...

here's what i think you could do:

use powershell to check out a folder, and then script out any objects.

then use powershell again to add any new items, and check in...

YSL i just created one and scripted it out for you.

This example is filtering for a specific databaseID (18) , for a specific user, and ignoring any '%exec sp_reset_connection%' commands...

would you consider adding a CLR procedure that gets the data instead? that seems like a much better way to go.

http://www.mssqltips.com/sqlservertip/1986/sqlclr-function-to-return-free-space-for-all-drives-on-a-server/