Viewing 15 posts - 7,411 through 7,425 (of 49,552 total)
Luis Cazares (10/25/2014)
GilaMonster (10/25/2014)
Anyone live anywhere where they can easily get a variety of different dried chillies? Stuff Costeño, New Mexico, Choricero, Arbol, Cascabel, Ancho, Mulatto, Negro, Pasilla?
I do, but...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2014 at 4:57 am
BWFC (10/25/2014)
GilaMonster (10/25/2014)
Anyone live anywhere where they can easily get a variety of different dried chillies? Stuff Costeño, New Mexico, Choricero, Arbol, Cascabel, Ancho, Mulatto, Negro, Pasilla?
Have you tried Amazon?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 26, 2014 at 4:55 am
Anyone live anywhere where they can easily get a variety of different dried chillies? Stuff Costeño, New Mexico, Choricero, Arbol, Cascabel, Ancho, Mulatto, Negro, Pasilla?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 25, 2014 at 3:41 pm
SQLKnowItAll (10/24/2014)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 25, 2014 at 5:56 am
Something in the job is filling the log, failing and rolling back, leaving the log empty again after it completes.
You're going to have to monitor log reuse reason and %...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2014 at 8:29 am
spaghettidba (10/24/2014)
SSMS opens multiple connections:1 for the editor window
1 for the object explorer
1 for the intellisense
And sometimes a few more for no good reason.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2014 at 5:48 am
You'll get an error. You reference the column name where the table name needs to be in the update and you reference a column which doesn't exist in that scope
This,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2014 at 4:21 am
Koen Verbeeck (10/24/2014)
spaghettidba (10/23/2014)
Jack Corbett (10/23/2014)
spaghettidba (10/22/2014)
Stefan Krzywicki (10/22/2014)
Of course, regionalisms mean it could be called most anything.
For example: In most of the USA, a blended milk and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2014 at 1:20 am
Don't use sysprocesses. It's deprecated, from SQL 2000.
Use the DMVs, sys.dm_exec_requests/sys.dm_exec_sessions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 2:50 pm
ScottPletcher (10/23/2014)
You can use system procedure:sp_rename
to rename a column.
He's trying to alias a column in a query with a dynamic name, not rename a column in a...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 2:49 pm
Can you post what you have so far please? It's not actually hard to do the highlighted portion, but easier to add to your existing code than write from scratch.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 2:48 pm
ramana3327 (10/23/2014)
I think it is possible, If there are 2 SQL Instances (Replicas) running on the same node, can they being part of the same AG?
I'm glad you think...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 1:40 pm
SQLKnowItAll (10/23/2014)
I assumed this meant pages of data from sql, but I suppose now that it could be anything on the server. Thoughts?
Only one. Figure out exactly what it's showing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 12:18 pm
ramana3327 (10/23/2014)
Is it possible to have AG created across multiple domains?
No.
Is it possible to have AGs created across VMs on same physical host?
Should be, but that's not a good idea...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 12:11 pm
What, exactly, do you mean by 'paging'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 23, 2014 at 12:00 pm
Viewing 15 posts - 7,411 through 7,425 (of 49,552 total)