Viewing 15 posts - 7,171 through 7,185 (of 49,552 total)
dnonyane (11/28/2014)
now as long as the users don't know these stuff they won't be able to interpret it.
Security by obscurity does not work.
What exactly do you mean by 'adding...
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
November 28, 2014 at 1:47 am
That's not all that helpful, expecially since Management throws an error on that XML. Could you maybe just attach the saved plan rather than making someone else fix the XML,...
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
November 28, 2014 at 1:40 am
No.
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
November 28, 2014 at 1:31 am
river1 (11/27/2014)
When will SQL Server 2014 will be released to be installed in production.I mean, when will I have a version that I can trust to put in production?
Last year,...
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
November 28, 2014 at 1:30 am
The latest
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
November 28, 2014 at 1:30 am
Don't script the data unless your database is under a couple hundred MB.
Script the schema, use bcp to export the data to flat files.
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
November 28, 2014 at 1:27 am
Actual execution plan please?
In the mean time, first thing to try is to replace all those table variables with temp tables. So:
CREATE TABLE #TCut([Val] [nvarchar](MAX) NULL)
CREATE TABLE #TColor([Val] [nvarchar](MAX) NULL)
CREATE...
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
November 28, 2014 at 1:24 am
How big is the index? How many pages (or how many kb)?
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
November 27, 2014 at 6:41 am
Same answer as I gave you before.
In this case, both tables were scanned once. The merge join is efficient when the two resultsets are in the order of the join...
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
November 27, 2014 at 6:10 am
If you just run the installer, you'll only be allowed to install a new instance (different name). If you want to replace an installation, uninstall then 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 recoverability
November 27, 2014 at 5:14 am
That's just a whole bunch of SET statements. It's not doing anything other than assigning values to session-scoped settings. There's no query there.
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
November 27, 2014 at 5:04 am
You've probably got no useful indexes for that query, so in the absence of indexes to support the WHERE and JOIN, SQL has to scan the table. The optimiser would...
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
November 27, 2014 at 5:02 am
The clustered index has the non-leaf levels that are additional to the data. They're small in comparison.
The clustered index does not enforce the physical order of pages within the data...
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
November 27, 2014 at 4:52 am
DBA From The Cold (11/27/2014)
A side-by-side upgrade is where you build a new server, install a later version of SQL and then migrate your databases.
Or install a new instance on...
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
November 27, 2014 at 2:43 am
SQL Server doesn't have incremental backups.
It has full database backups, differential database backups and log backups. Which are you asking about?
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
November 27, 2014 at 2:12 am
Viewing 15 posts - 7,171 through 7,185 (of 49,552 total)