4
Tuning the sql server
source link: https://www.codesd.com/item/tuning-the-sql-server.html
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Tuning the sql server
advertisements
how does the query optimizer determine estimated row size when we execute any query?
SQL Server uses statistics and the current data set to do this analysis. Here is a very detailed link covering the data SQL 2008's query optimizer uses to calculate this for you.
Also, this link goes into more detail as to exactly how the optimizer generates a query plan with an internal estimate of rows.
Related Articles
Performance Issues on the SQL Server + .net C # Application
I support an application that runs on SQL Server and was developed on .net c#. The application gets its information from the local system (ERP) and process it in a few batches during the day (most of the times, it'll be in just one batch). Then it pr
.NET timeout but not the sql-server console
I have a query which takes 10 seconds from the sql-server console but I get timeout from a program written in VB (language). What can be the reason that I get timeout from my program but works fine from sqlserver console? My code: Public Shared Funct
Extend the Excel changes to the sql server table
So I'm in Excel and I connected to my SQL Server Table. I updated a couple columns in Excel. column1,column2 updated1, updated2 updated3, updated3 Is there a way in the VBA Immediate Window to run an update statement to propagate the changes back to
Importing data from Excel to multiple tables in the Sql Server database
I have an excel sheet where in the data looks similar to the table below : EmployeeName Manager Name E1 M1 E2 M2 E3 M3 E4 M1 I need to export this into a database which has two separate table for employee and manager. Sql tables which I am exporting
The SQL Server service continues to stop on a local machine
I have some update or something that tries to run every night, and ends up leaving the SQL Server service stopped. When the machine restarts, the service restarts properly. How do I go about diagnosing and fixing what is breaking my SQL Server servic
The most efficient way to store a GUID value in the SQL Server database
Say, if I need to store non-repeating GUID values (something like {AB50C41E-3814-4533-8F68-A691B4DA9043}) in the SQL Server database, what is the most efficient way to define the column to store it? (i.e. as string, a blob, or convert it into a 16-by
Lost the ODBC connection with the SQL Server 2005 database
One of our clients has an application (FoxPro 9) running on top of a SQL Server 2005 backend. Intermittently, they are losing their ODBC connection with the SQL Server database. Below is the initial error information: Err Msg: Connectivity error: [Mi
The Analysis Services Processing Task Fails When Runed by the SQL Server Agent
I have an SSIS package which contains an Analysis Services Processing Task. This package is kicked off by a SQL Server Job in SQL Server 2008 R2. If I run this job myself or process the cube manually everything is fine. However if I schedule the job
Unable to boot the sql server in single user mode
I'm trying to recover my local sql server's sa password. I read that I should put it in single user mode, and I did that. I added the -m; to the startup parameters. I don't have sql agent running, and I restarted the Sql Server. When I try: sqlmd -S
How to enable the FILESTREAM function in the sql server 2008 developer edition
I have a problem in activating the filestream feature in sql server 2008 I have done the following steps but could not succeeded.. 1) ran the sql server management studio as an administrator, right click the server instance and Facets, dialog is open
Connect to the Sql Server 2014 database in Azure VM
I just created a new SQL Server 2014 VM from Windows Azure gallery. I did remote login into VM , on trying to login into DB with Windows Authentication mode, I get below error: Login failed for user 'dbserver\dba1'. (.Net SqlClient Data Provider) Are
Deploying Java Applications with the SQL Server Database
I developed a java swing application by using hibernate connection and MS SQL server for database. Application is working fine. And I know the way to create and EXE and the installer for application.My question is, how I install this application to a
The detailed view of ASP.NET VB.NET does not update a column in the SQL Server database
I am at a standstill. I have two detailsview forms to insert new records. In form 1 everything works and all columns are updated in the SQL Server table. In form 2 (which is almost the same as the first form, form 1 has a filter) doesn't update one c
Simulate the SQL Server database down
I've written an application that connects to a system over the network and logs events from that system to a SQL Server database. I need to test the behaviour of the application when the SQL Server goes down. Is there a way to Kill just the one Datab
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK