Viewing 15 posts - 3,781 through 3,795 (of 19,560 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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 10, 2014 at 9:41 am
timSF (2/9/2014)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
http://www.sqlservercentral.com/articles/Fuzzy+Match/65702/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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? ...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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]';
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 9, 2014 at 10:55 am
Yes please share what you have so far.
Do you have a table structure?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 8, 2014 at 10:00 pm
Could you provide more information such as sample data, desired output and table structure?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 8, 2014 at 3:47 pm
Viewing 15 posts - 3,781 through 3,795 (of 19,560 total)