Viewing 15 posts - 1 through 15 (of 102 total)
i totally read the question wrong, for some reason in my head i was thinking how many columns since that was the first thing i was thinking about, but the...
September 29, 2014 at 8:23 am
adonetok (3/14/2014)
Can you tell me how to generate index scripts for one table? I need to apply the...
March 14, 2014 at 7:25 am
Nothing really to see, they just prefer things to be easy than to be done the right way. If they don't care about how accurate data is then lose the...
February 25, 2014 at 9:28 am
EricEyster (2/25/2014)
I highly recommend using database roles for this requirement. Assign the permissions to the role and the next time around you just add the user to the role.
Another suggestion...
February 25, 2014 at 7:59 am
If I were you I would look into sp_whoisactive, much better than sp_who2
February 25, 2014 at 7:57 am
GilaMonster (2/24/2014)
stormsentinelcammy (2/24/2014)
GilaMonster (2/24/2014)
Tune the query, tune the indexes. Without more information that's about all that can be said.
Also, if you have an inline table switch to a temp table...
February 24, 2014 at 8:27 am
GilaMonster (2/24/2014)
February 24, 2014 at 7:24 am
GilaMonster (2/24/2014)
Tune the query, tune the indexes. Without more information that's about all that can be said.
Also, if you have an inline table switch to a temp table so that...
February 24, 2014 at 7:18 am
rickyc1 (2/21/2014)
February 21, 2014 at 12:05 pm
SQLRNNR (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.
You'd hope if you're working on...
February 21, 2014 at 11:51 am
Steve Jones - SSC Editor (2/21/2014)
stormsentinelcammy (2/21/2014)
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.
You'd hope if you're working on instances...
February 21, 2014 at 11:49 am
Steve Jones - SSC Editor (2/21/2014)
Not I. I'd pass on that job. I like my family and bed.
You'd hope if you're working on instances that big that you'd be doing...
February 21, 2014 at 8:50 am
Luis Cazares (2/21/2014)
Do you understand how and why it works?
I also missed the link in my previous post. Here it is: How to Make Scalar UDFs Run Faster (SQL...
February 21, 2014 at 8:30 am
Just wondering but when you created the linked server did you pass the sa/sa password for the username/password for the connection to the production server, small things like that could...
February 20, 2014 at 2:52 pm
You might want to source the problem instead of just sending an email, try to create a table to write what procedure is running so that you can try to...
February 20, 2014 at 2:06 pm
Viewing 15 posts - 1 through 15 (of 102 total)