No announcements
Categories
-
Select allSQL Server Data WarehousingSQL Server Integration ServicesData MiningSQL Server Reporting Services, Power ViewSQL Server Analysis ServicesSQL Server ToolsTransact-SQL.NET Framework inside SQL ServerSQL Server Data AccessSQL Server SMO/DMOSQL Server XMLSQL Server ReplicationSQL Service BrokerSQL Server SecuritySQL Server Database EngineSQL Server DocumentationSQL Server Setup & UpgradeSQL Server High Availability and Disaster RecoverySQL Server Notification ServicesSQL Server CompactGetting started with SQL ServerDatabase MirroringSQL Server ExpressMicrosoft Drivers for PHP for SQL ServerSQL Server SearchSQL Server SpatialDatabase DesignSQL Server Master Data ServicesSQL Server ManageabilitySQL Server PowerPivot for SharePointSQL Server PowerPivot for ExcelSQL Server Application and Multi-Server ManagementSQL Server Samples and Community ProjectsMicrosoft StreamInsightSQL Server MigrationSQL Server Data Quality ServicesSQL Server Distributed Replay
-
Select allSystem Center Mobile Device Manager
-
Select allBizTalk Server GeneralBizTalk Server Adapters and Adapter PackBizTalk Server EDI and AS2BizTalk Server RFIDBizTalk Server Host Integration Server
-
Select allExchange Server 2013 - General DiscussionExchange Server 2013 - Administration, Monitoring, and PerformanceExchange Server 2013 - High Availability and Disaster RecoveryExchange Server 2013 - Outlook, OWA, POP, and IMAP ClientsExchange Server 2013 - Mobility and ActiveSyncExchange Server 2013 - Setup, Deployment, Updates, and MigrationExchange Server 2013 - Extended Components, Tools, and UtilitiesExchange Server 2013 - Mail Flow and Secure MessagingExchange Server 2013 - Unified MessagingExchange Server 2013 - Sharing and Collaboration: Site Mailboxes and Public FoldersExchange Server DevelopmentExchange Server 2013 Preview (locked)
-
Select allTechNet Website FeedbackMSDN and TechNet Search FeedbackTechNet Wiki Discussion
-
Select allForefront Identity Manager 2010
-
Select allMicrosoft Operations Framework -- MOF 4.0
-
Select allIT Management Planning and Technology
-
Select allTraining and Certification
-
Select allLive Meeting General DiscussionLive Meeting - Creating, Joining Meetings, Configurations and SettingsLive Meeting - In Meeting Experience, Console and Add-insLive Meeting - Media DiscussionLive Meeting - Rollout/Deployment Programs
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky3VotesMicrosoft TechNet Wiki Guru - Winners for May
The results for May's TechNet Guru competition have been ...
-
Sticky2Votes
Are you a technology guru? Show us your solutions and become the T-SQL Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert, or authority on T-SQL? Show us your ... -
Sticky0Votes
POSTING TIPS - source code, screen images, details within...
When you're posting a question - please search the forum first! If that fails, and you wish to include T-SQL, C#, or VB code in your post, see below. If you want to show us what you see on ... -
Sticky0Votes
Solutions to Common T-SQL Problems
The Volunteer Moderators andAnswerers who support the Microsoft MSDN SQL Server Forums have created a Wiki to present Solutions to Common T-SQL Problems. Check here to see if ...
-
Unanswered0Votes
Can you set a single FILEGROUP to READONLY without getting exclusive access to the entire DB?
I'm in the process of building a partitioned table with a sliding-window partition. I have several years of historical static image data that will be moved to individual filegroups created to ... -
Unanswered0Votes
INDEX of column(s) in ORDER BY with OFFSET and FETCH
I am using SQL Server 2012 to try to implement efficient paging using OFFSET and FETCH. Here's some sample code: SELECT ID, Name, ... , ColumnZ FROM ... -
Answered0Votes
Why SQL_Hungarian_CP1250_CI_AS is case sensitive ?
Hi, I have the following databaase : CREATE DATABASE Hungarian COLLATE SQL_Hungarian_CP1250_CI_AS USE ... -
Unanswered0Votes
Need help with Subqueries in FROM clause
Hi, I'm novice with SQL and this is my first post on the forum. I hope to learn quickly to help those who need my time. My question ... -
Unanswered1Votes
Average for the last ten days repeated row by row
0,REVEN,0)) AS RICAVI FROM BERLIN GROUP BY QUA) SELECT QUA, COSTI-RICAVI as media FROM CTE I got: date and average 2013-03-12 ... -
Unanswered0Votes
Query help needed
Hi I have a requirement and I am not sure how to go about it. I have a Shipment query Datatypes ticketnum ... -
Unanswered0Votes
Simple way of changing from rows to columns?
I would like to use this result with an ssrs chart, but apparently, it would be easier for the chart to 'display' this if it were column-wise instead of rows. Is there a relatively ... -
Proposed1Votes
-
Answered0Votes
Alt+F1 , SP_HELP
Hi Friends, i have alter some column length of Tables, now i am checking the same table by hitting Alt+F1, it is still showing old values EG Fname ... -
Answered5Votes
Inconsistent performance of a script
Have you ever written a complex script and 99 times out of 100 it does EXACTLY what it is supposed to do? Then on that 100th run it does something unexpected? Like a record that should have gotten ... -
Proposed0Votes
Sql Dependent Queries Not Automatically Recompiled
Hi there, I am a simple guy, wondering what is going wrong: I make 2 TVF's the second depending on the first. If I alter the first, the second one still used the ... -
Answered3Votes
Using UPDATE with MERGE When Data Hasn't Changed
In my MERGE statement, my source and target are mapped on the BenefitLookupGroup1Key (see query below). If that value matches between the source and target tables, an UPDATE between the two tables ... -
Unanswered0Votes
extract parameter names and values from a string
Hi - We have a stored procedure log that records the parameters and values for each stored procedure that is executed. In an effort to make a particular stored procedure run more efficiently, it ... -
Proposed4Votes
Accessing local instance error
Hi, I have ssms in my local and generally I connect to the servers which my team says. Now I want to connect to my local itself to do some development work but ... -
Unanswered0Votes
DATEDIFF II
Hello, Some question has already been answered here, but I'm still getting a hard time, maybe you could enlighten me... (First ... -
Proposed0Votes
Non cluster index setup Help
Hi Friends, i have below kind of table strucuture Table_A (table_a_id int (PK), col_1 varchar(50), Col_2 varchar(50), Col_3 varchar(50),COl_4 ... -
Unanswered2Votes
Are you a technology guru? Show us your solutions and become the T-SQL Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert, or authority on T-SQL? Show us your ... -
Answered0Votes
How do I optimize this simple query
Hi everyone, I am using the following query in an application. Basically, the query shows account balances for the last 2 years. I need to get the same query to show data for the ... -
Answered1Votes
Balance Snapshot and Lag Window Function
Having read the books - I understand that a daily snapshot should - by definition - be taken every day. I am in the specialty credit card space. Ours is not a daily use card. ... -
Unanswered0Votes
Last Recent Record with Value from other column
drop table #abc CREATE TABLE #ABC ( CompnayID INT, TrainingCompanyID INT, CategoryID INT, ItemID INT, LastTrainedBy ... - Items 1 to 20 of 64337 Next ›
.png)
