Viewing 15 posts - 121 through 135 (of 280 total)
jshahan (4/19/2012)
READY!
FIRE!
AIM!
Yeah, I’d probably suggest that getting context might be the first step prior to criticizing this BAD DESIGN!
For starters, nothing here suggests any kind of permanent data modification. ...
April 19, 2012 at 11:00 am
jshahan (4/19/2012)
I want to call a SQL CLR function in a SELECT to add values to a list but not return any value to the SELECT. The problem...
April 19, 2012 at 9:22 am
This is impossible to answer without know the make/model of both the SAN and HBA's (including firmware and driver versions), multipathing software.
Also, you're pretty much stuck believing what he tells...
April 19, 2012 at 9:00 am
CameleWeb (4/18/2012)
Can you try using a temp table and see if you can reproduce the issue?
Hi!
By temp table, do you mean to create a similar table, with the same content,...
April 19, 2012 at 8:25 am
Don't forget about backups.
Sql Server doesn't have an undo button, and your time is valuable. The 15 minutes it will take for you to configure backups could...
April 18, 2012 at 10:58 am
naran.vekaria (4/18/2012)
Hi,Thanks for that I'll test this and use it to prevent it from occuring.
Is there any way to check what may be changing the 'Enforce Password Policy' option?
Thanks
In...
April 18, 2012 at 10:26 am
the recommended process to patch a 2k8 cluster with minimal downtime is to remove the secondary node as a possible owner, patch it, re-add it as an owner, failover to...
April 18, 2012 at 9:45 am
Policy Based Management can accomplish this.
You can have the policy evaluated on change and either log or prevent the change from occuring if it doesn't meet the requirement.
Here's some sample...
April 18, 2012 at 9:42 am
An Availability group is a set of databases that is accessed through a specified virtual network name.
An availability replica is a copy of the databases in an availability group on...
April 18, 2012 at 9:09 am
can you post the schema for the table and all indexes.
also, can you get the execution plan for the problematic update statement?
April 16, 2012 at 3:33 pm
Jack Corbett (4/13/2012)
I know very little about FTS, so how does it handle BLOB data types since the OP has an NVARCHAR(max) column in the FTI?
The base table...
April 13, 2012 at 4:13 pm
As I've recently tackled some Full-text performance problems, I'll throw out some possibilities.
1. The FTS engine does have some caching in it. There is no documentation on what/when/how it...
April 13, 2012 at 3:18 pm
Cross db ownership chaining.
In ssms, the login is mapped to users in both databases.
in the agent job, (or in a stored proc with ' execute as') the login no...
April 10, 2012 at 2:34 am
Service broker might work here as well. You could queue up all the databases, and use an activation proc to call ola's script. Then you can adjust the...
April 10, 2012 at 1:51 am
Ralph Kimball outlines a sql based approach for this kind of market basket analysis.
http://www.kimballgroup.com/html/articles_search/articles1999/9904IE.html?TrkID=IE199904
This article assumes you've got a firm grasp on Dimensional Modeling, ETL's and Data Warehousing.
Good Luck!
April 3, 2012 at 9:24 am
Viewing 15 posts - 121 through 135 (of 280 total)