Forum Replies Created
Viewing 15 posts - 61 through 75 (of 49,552 total)
-
RE: Are the posted questions getting worse?
jasona.work - Thursday, October 25, 2018 12:15 PMGail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
RE: MAXDOP ,Server Core & SELECT
VastSQL - Tuesday, October 23, 2018 6:59 AMGail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Backups to URL flooding log
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: A check constraint referencing another column
Nothing wrong with the code you posted. Error must be somewhere else.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: A check constraint referencing another column
You're missing a comma.
CREATE TABLE employeeMasterFile (
Vendor varchar(30) NOT NULL,
Address varchar(30),
City varchar(20),
Email varchar(30),
State char(2),Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: A check constraint referencing another column
Correct, the constraint is between the two columns, it applies to the table Medicaments
Let me repeat something I said earlier:
Other than default and not null, constraints are...Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: A check constraint referencing another column
You're getting confused with the 'table constraint' and column constraint'. Other than default and not null, constraints are objects applied to the table. There aren't two types of check constraints....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Monitoring slow running queries of different variety of SQL Server versions without any 3rd party tool.
For 2008, this works without change: https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server-part-1/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Maxmemory setting in active-pasive cluster.
mig28mx - Thursday, October 18, 2018 6:26 PMYes
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Multiple TempDB files in Azure
You don't. SQLDW is a hosted database, you have no control at all of anything outside of the database. The details of the server, server config, hardware is managed for...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Move entire SQL instance from C:\ to D:\ directory....HELP !
Uninstall. Reinstall
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Help pls: upgrading from sql 2005 to sql 2008
Thom A - Thursday, October 18, 2018 3:30 AMGail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Help pls: upgrading from sql 2005 to sql 2008
It'll work fine with the encrpyted procs, but you really need to be moving to something newer. 2008 is out of support, has been for a while now. Yell at...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: RecordDate, UpdateBy, CreatedDate, CreatedBy, columns.
There's no formal definitions of any of those. Ask the developers of the specific system you're working with what the various columns contain.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passRE: Is it possible to query details on a specific index?
DBCC IND and DBCC PAGE (and google will get you the syntax and details). They're undocumented commands
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may passViewing 15 posts - 61 through 75 (of 49,552 total)