SQL Server

Part 1ArticleWe have summarized the timeout settings in Sharepoint. The article says that SQL-side options will not have any impact. Why? I was dizzy, so I went to consult Peter, a Senior Technical Support Engineer of SQL and got the following

SQL ServerType C #Type Exact number Bigint Integer Data from-2 ^ 63 (-9223372036854775808) to 2 ^ 63-1 (9223372036854775807) (All numbers ). The storage size is 8 bytes. Int64

When I use SQL Server Management studio of SQL Server 2005 to create a view, it seems that there are the following problems: I use it to create a view of the database under SQL Server 2000: In the view, use select * From sometable to create a view,

In enterprises, various data are distributed in various scenarios. For example, an enterprise may use an Excel or My SQL database before adopting an SQL Server database. They have different formats and different storage locations. However, managers

In the stored procedure of SQL Server, according to the requirements of the business logic, sometimes a custom exception needs to be thrown #ProgramCapture and perform corresponding processing.SQL Server throws a custom exception and is simple, like

  【Recommendation]SQL Server One of the uncommon applications Obtains the basic information, Field List, and stored procedure parameter list of a table.   -- Establish a personal brand through knowledge sharing.   1. obtain

Http://support.microsoft.com/kb/317604   Typically we used in-Proc mode to store Asp.net session state, but, sometimes we can not use the mode for some desire. Like using load balance or use long timeout session. So. We need out-Proc mode to make

Free SQL server tools that might make your life a little easier Update: new stuff from the latest update will be inRed. This list will grow as I find new tools. So if you know of some not on this list do post them in the comments. SQL Server

Source data (text files) A large amount of historical stock data has been downloaded in the text format: The first line of each file contains shares.Code, Stock name, data type. The second row is the name of the data column: Data Table A

ERP reports are often made, involving reading data during the stored procedure, reading data associated with multiple tables, and using a cursor. Typical Example of reading a user table cursor declare @ age int declare @ name varchar (20)

1. Handle deadlocks and set deadlock priority A deadlock occurs when multiple users apply for different blockages. The applicant has part of the blockages and waits for the blockages of other users. Set deadlock_priority can be used to control

SQL Server Date and Time Functions 1. Common date methods (the following getdate () = '2017-11-08 13:37:56. 123 ') (1)Datename(Datepart, date) Returns the string that represents the specified date part of the specified date.

Recently, I used a SQL Server cache to increase the data volume by a day and receive queries from customers. The speed is getting slower and slower as the data volume grows. Review Frequently Used Indexes I. Clustered Index The page level of

SQL Server allows user-defined functions. Microsoft SQL server does not restrict users to built-in functions defined as part of the transact-SQL language, but allows users to create their own user-defined functions. A function is a child that

Note:Disaster recovery SeriesOfArticleYesby Robert Davis Written in sqlsoldier,I personally think it is quite good, so according to my own understanding, testing and sorting are not directly translated. If there is any inaccuracy, please correct me.

We have achieved the goal of importing data from Excel to the data stream, that is, the database. However, we only simulate data that does not repeat, that is, data that does not exist in the Database at this time. if the data in the Excel worksheet

Some time ago, the boss gave a requirement that some tables should be sharded. Therefore, the stored procedure, table names in views and functions in the original database should also be updated, at the beginning, I tried to manually check several

After a period of research, we started to optimize the performance this week. Before optimization, I will summarize some of the information I have investigated. 1. Background This is a system developed in the past 03 years. NET 1.1 + SQL Server 2000,

Introduction The SQL statements we usually write are essentially the logic for obtaining data, rather than the physical path for obtaining data. When the SQL statements we write are passed to the SQL Server, the query analyzer parses, binds, and

Description: The hardware and software environments used are Windows XP SP2, SQL Server 2000 SP2 Personal Edition, General dual-core desktop, M LAN, and host A is an existing Server with databases and massive data, machine B is the new server. Both