Viewing 15 posts - 9,736 through 9,750 (of 49,552 total)
I'm feeling like a parrot today.
"Let me repeat what has already been said in this thread"
"Let me repeat what I said earlier in this thread"
"Let me quote the answer to...
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
March 11, 2014 at 5:36 am
Sure.
You ensure that every single piece of code that could ever possibly update the deleteflag of tablA also goes and updates the deleteflag of the other tables.
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
March 11, 2014 at 5:32 am
yuvipoy (3/11/2014)
GUIDs certainly can be used as clustered indexes, nothing prevents that.
why not if it is not alpha numeric?
Don't understand...
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
March 11, 2014 at 5:18 am
You need a trigger for that.
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
March 11, 2014 at 5:15 am
Chapter 4: http://www.red-gate.com/community/books/accidental-dba
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
March 11, 2014 at 5:09 am
GUID ordering is not alphanumeric. There's articles on the web which describe how GUIDs are ordered, not that it usually matters much for users.
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
March 11, 2014 at 4:23 am
Um....
GilaMonster (3/11/2014)
The publisher is the database you're working with.
i.e. the one you're trying to change the primary keys in. So you've already found it.
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
March 11, 2014 at 4:01 am
Do you have a performance problem at the moment?
If not, then design your database according to good data design principals (including picking the correct data type for the expected...
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
March 11, 2014 at 3:54 am
praneethydba (3/11/2014)
Client is asking to reduce the memory utilisation for DB server...
Tell the client that
SQL Server will take all of the memory - up to the max memory setting -...
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
March 11, 2014 at 3:53 am
Again, why is that a concern?
From earlier in this thread:
SQL Server will take all of the memory - up to the max memory setting - that it needs. If you...
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
March 11, 2014 at 3:24 am
Silverfox (3/11/2014)
however doesnt using tablock, switch to using tempdb for the work that is carried out.
No. It switches to using table locks for stability rather than a database snapshot.
But i...
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
March 11, 2014 at 3:21 am
praneethydba (3/11/2014)
Now the memory Utilisation is 70%...what to do?
Nothing?
Why do you feel that something needs to be done? What problem are you trying to solve here? What is 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
March 11, 2014 at 2:42 am
The publisher is the database you're working with. As for changing the replication, go speak with the DBA/developer who set the replication up.
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
March 11, 2014 at 2:40 am
Are you editing out the filenames in those messages, or is SQL really reporting extensions without names?
Operating system error 1450: http://blogs.msdn.com/b/psssql/archive/2008/07/10/sql-server-reports-operating-system-error-1450-or-1452-or-665-retries.aspx, so you may not be able to use 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
March 11, 2014 at 2:28 am
Consumes more space than what?
If you want a list of the tables and their sizes, have a look at the sys.dm_db_partition_stats DMV.
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
March 10, 2014 at 10:10 am
Viewing 15 posts - 9,736 through 9,750 (of 49,552 total)