Search results for "4982.com.cn"

Your search for "4982.com.cn" returned 22 results:

Technical Article

Partation SWITCH error

  • Topic

Hi, I use followig sql statement to create a partation table and i am getting error message in SWITCH . CREATE PARTITION FUNCTION pf_year (int) AS RANGE LEFT FOR VALUES ( 1960, 1970, 1980, 1990, 2000 ) CREATE PARTITION SCHEME ps_year AS PARTITION pf_year ALL TO ([PRIMARY]) --table creation create table dp_test1 ( col1 int […]

You rated this post out of 5. Change rating

2011-07-23

1,006 reads

External Article

Transform your SQL Server permissions

  • Article

SQL Census helps users understand who has access to their SQL Servers (including Active Directory groups) and simplify existing SQL Server permissions. A new feature reworks discrete user permissions into database roles, giving users the same effective rights in a more controllable structure. Download and use SQL Census (in preview) for free.

2019-03-07 (first published: )

4,982 reads

Technical Article

Removing partially duplicate records in SQL

  • Topic

Hello, I have a table with 1 billion records and I'd like to delete some records that are partially duplicate. Ex) the table below has three records RECID COL1 COL2 COL3 --------------------------------------- 1 A B C 2 A B 'blank' 3 A 'blank' C As you can see, RECID 2 and RECID 3 are duplicates […]

You rated this post out of 5. Change rating

2008-10-14

174 reads

Technical Article

How to get rid of the dotted separation line from a text file output?

  • Topic

Hello folks I am recently trying to output a query result into a text file but seems to unable to get rid of the dotted separation line between the column names and the row data. Here is an example from the command line (assuming you have 'pubs' db on a local default instance): sqlcmd -E […]

You rated this post out of 5. Change rating

2010-09-23

1,105 reads

Technical Article

ALTER TABLE ... SWITCHing from regular table to partitioned table fails

  • Topic

The code below does the following: 1) Creates a database play_partition in C:\TEMP 2) Creates two identical partitioned tables play_table and archive_play_table 3) Switches play_table partition 1 to archive_play_table partition 1 4) Creates a new unpartitioned table temp_table with the same structure as play_table on the same filegroup as play_table partition 2 5) Switches play_table_partition […]

You rated this post out of 5. Change rating

2014-07-07

237 reads

Technical Article

Help understanding Page Faults/sec results

  • Topic

We are receiving a lot of complaints about poor performance with an application.  The only possible issue I see on SQL Server is memory.  I ran perfmon for the following counters over a 30 minute window.  While perfmon was running, the users said performance dropped during a 10 minute portion of this window.  Below are […]

You rated this post out of 5. Change rating

2005-12-16

3,461 reads

Technical Article

Merge Replication (Timeouts)

  • Topic

Hi Guys, I am at a new client which I don't know very well yet... What they have in place: The PDAs have a SQL Server compact edition database. The users insert data on them on a daily basis. The PDAs are then sincronized (using merge replication) . The sincronization is between the database of […]

You rated this post out of 5. Change rating

2015-11-03

125 reads

SQLServerCentral Article

Fixing MLS Python Services to Load the Runtime

  • Article

Recently I went to work on a SQL Server 2017 instance and couldn't get the Python runtime to load. I'd keep getting this error: A strange error for me to see, and one that didn't quite make sense. How can the runtime not launch? However, restarting the instance still resulted in this error: Msg 39021, […]

You rated this post out of 5. Change rating

2019-10-24

6,482 reads

Blogs

Why the masters and what lies ahead

By

I recently graduated with a Master’s in Strategic Communication from the University of Delaware....

Copilot Reminded Me How To Find a File Handle

By

Recently I was trying to delete a folder and kept getting the “something is...

Planview Portfolios REST API with ADF – Retrieving Actual Data

By

In the introduction of this blog post series, I explained the use case: extracting...

Read the latest Blogs

Forums

Filtered index prerequisites to be used

By Martass

Hello, After few videos and  showing how filtered indexes works, what are the prerequisites...

Enhancing Web Application Performance through Database Optimization: A Comprehensive Study

By nai3

Comments posted to this topic are about the item Enhancing Web Application Performance through...

Automated Azure SQL VM Patching

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Automated Azure SQL VM Patching

Visit the forum

Question of the Day

Automated Azure SQL VM Patching

There is an Automated Patching service for VMs running SQL Server in the Azure Cloud. This uses the SQL Server IaaS Agent Extension to work with PowerShell. What types of patches are installed with this service? Note: All updates are marked with tags, such as Important, Critical, or something else

See possible answers