Viewing 15 posts - 7,831 through 7,845 (of 49,552 total)
Alex-489474 (9/15/2014)
If the server is back again, can I force the replication agent to start a complete replication so that the local changes are overwritten by the server?
You can invalidate...
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
September 15, 2014 at 2:53 am
That's just normal transactional replication. Providing the person working on the subscriber doesn't delete, insert or change the key values, updates won't break replication. Be aware that his changes will...
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
September 15, 2014 at 2:45 am
Firstly, don 't change minimum memory per query unless you know what you're doing and why you're changing it and the impact thereof.
Do you mean the server's memory usage is...
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
September 15, 2014 at 2:40 am
Lempster (9/15/2014)
GilaMonster (9/11/2014)
cafescott (9/11/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
September 15, 2014 at 2:31 am
elham_azizi_62 (9/15/2014)
how to reach output of checkDB?I post one of error wich was occured.
Run it again if you didn't save the output. I need to see everything that CheckDB returned.
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
September 15, 2014 at 2:28 am
New as in 'in development' or new as in 'here's an existing system you've never seen before'?
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
September 15, 2014 at 2:26 am
peterausger (9/14/2014)
When i execute it , its giving me following error..Incorrect syntax near '-'.
How can i make it work???
There's nothing wrong with your procedure, you just have to put the...
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
September 14, 2014 at 11:15 am
Sometimes advice on a blog still scares me. Not often, but sometimes. Like today
Consider using a RAMDisk for Index filegroups.
Putting non-clustered indexes on a RAMDisk will...
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
September 14, 2014 at 11:10 am
Please post the full output of that CheckDB statement, the entire thing, no edits, no omissions.
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
September 14, 2014 at 11:07 am
freddyism00 (9/13/2014)
ok I think I kind of figured it out, it's sort of memory-optimized....
Not really.
they compress the columns into segments and store them on disk as BLOB's, the columnstore...
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
September 13, 2014 at 5:15 pm
That's what you get when marketing gets to name features.
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
September 13, 2014 at 11:12 am
SQL DJ (9/13/2014)
What do you mean by execution plan ?
The graphical execution plan which management studio can show you, the 'recipe' if you will of how the query is executed.
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
September 13, 2014 at 5:07 am
defyant_2004 (9/12/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
September 13, 2014 at 5:07 am
Luis Cazares (9/12/2014)
Is this thread full of spam? Or is it a real problem with valid suggestions?http://www.sqlservercentral.com/Forums/Topic1612977-131-1.aspx
I suspect the former, though don't know enough about Access.
Same with the SQL corruption...
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
September 13, 2014 at 5:04 am
They're not in the log file. They're perfmon counters.
Don't believe everything SCOM tells you. Buffer cache hit ratio is a fairly useless counter.
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
September 12, 2014 at 1:29 pm
Viewing 15 posts - 7,831 through 7,845 (of 49,552 total)