Viewing 15 posts - 3,781 through 3,795 (of 19,564 total)
On the affected server, what is the power setting within windows?
What is the power saving mode set to in the BIOS?
If power saving is enabled in the BIOS you could...
February 10, 2014 at 9:50 am
Does the clr involve multiple tables that have PK - FK relationships? Possibly a circular relationship between those constraints?
February 10, 2014 at 9:41 am
timSF (2/9/2014)
February 10, 2014 at 9:34 am
It sounds like you are looking at a Jaro-Winkler type of requirement.
Here is an article on that
February 9, 2014 at 10:18 pm
please don't cross post.
If posting answers, please post them to the original thread.
http://www.sqlservercentral.com/Forums/Topic1539055-364-1.aspx
February 9, 2014 at 10:15 pm
Very nice article. I like the points raised. I am in particular agreement with "Be a teacher, not a bully" and to not include the world in communications....
February 9, 2014 at 10:13 pm
Jeff Moden (2/9/2014)
TheSQLGuru (2/9/2014)
Jeff Moden (2/9/2014)
TheSQLGuru (2/9/2014)
Please provide several sample sets of data and the corresponding table output you expect (with column data types). That's JSON, yes?
THAT's JSON? ...
February 9, 2014 at 10:07 pm
Try this
SELECT p.name,p.type_desc
FROM sys.server_principals p
WHERE p.type LIKE '[GUS]';
February 9, 2014 at 10:04 pm
Nice question.
Not sure why someone would try to create the same temp table twice in the same procedure. If needing to use the same temp table then clear it...
February 9, 2014 at 11:22 am
stefan 97267 (2/9/2014)
Perfect, thank you.But (there always is one)
The database has many tables,if i want to compare and insert on the schema level not table by table, is that possible?
No,...
February 9, 2014 at 11:16 am
This is typically due to a .Net mismatch.
With other versions it was required to use the .Net2 even though .Net4 was installed.
My 2012 instances return this value
versionv2.0.50727
Do you have multiple...
February 9, 2014 at 10:55 am
Yes please share what you have so far.
Do you have a table structure?
February 9, 2014 at 10:44 am
Check security and see if the windows logins or groups exist there. If they do, then you have logins in SQL Server that are using windows authentication.
Next check under...
February 8, 2014 at 10:00 pm
Could you provide more information such as sample data, desired output and table structure?
February 8, 2014 at 9:53 pm
Frankly, I think you need to hire a consultant. A consultant can get logshipping to work in your current environment. A consultant could also write some procedures for...
February 8, 2014 at 3:47 pm
Viewing 15 posts - 3,781 through 3,795 (of 19,564 total)