Business Technology News and Commentary - InformationWeek
4 Comments NBA CIO Focuses On Analytics, Data And Fans 7 Comments SnapLogic CEO Talks About Changing Role Of IT 9 Comments Changing IT Organizations: Anaplan 1 Comments Accenture Strategy Talks Digital Strategy ..
Technet Evaluation Center
Click Download, select your file type, complete registration, and monitor the progress of your download with the embedded status bar in the top toolbar. It is customized based on your own personal experiences, connected to community and social sites, and includes cool new features to make your day job just a bit easier
Microsoft SQL Server interview questions for DBA and database developer positions: Narayana Vyas Kondreddi's home page
How to determine the service pack currently installed on SQL Server? The global variable @@Version stores the build number of the sqlservr.exe, which is used to determine the service pack installed. Check out BEGIN TRAN, COMMIT, ROLLBACK, SAVE TRAN and @@TRANCOUNT What is an extended stored procedure? Can you instantiate a COM object by using T-SQL? An extended stored procedure is a function within a DLL (written in a programming language like C, C++ using Open Data Services (ODS) API) that can be called from T-SQL, just the way we call normal stored procedures using the EXEC statement
I wish I can say I learned a ton, but honestly most of what I know has come through self-teaching and the degree is more of just a piece of paper to help me get into the field. He is guiding me right now, but can I start as a fresher for DBA with my 6 months experience as business analyst.I troubleshoot the technical issues faced by the users of Altria
Is there a query to retrieve the partition ranges? In my example I am expecting to see the list of current partition ranges like Jan2011, Feb2011 Thanks. USE TestDB; GO --- Step 6 : Insert Data in Partitioned Table INSERT INTO TestTable (ID, Date) -- Inserted in Partition 1 VALUES (1,GETDATE()); INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2 VALUES (11,GETDATE()); INSERT INTO TestTable (ID, Date) -- Inserted in Partition 2 VALUES (12,GETDATE()); GO Step 7 : Test Data from TestTable Query TestTable and see the values inserted in TestTable
SQLServerCentral.com
58 731 Wednesday, April 8, 2015 4:39 AM In: RE: Movie Rental Database By Grant Fritchey Hardware Discussions about SQL Server hardware and sizing your servers. 614 2,213 Wednesday, February 25, 2015 10:46 PM In: RE: Project Plan By Sachin Butala-182900 Working with Oracle Questions and comments about configuring, connecting to and troubleshooting SQL Server 7 or 2000 to Oracle databases
Using DPMBACKUP to back up the DPMDB Pro - Easy to run for instant ad-hoc backups Pro - Can be scheduled using Windows Task Scheduler to run as often as you like. This post will not cover setting up a backup vault and installing the Azure agent on the DPM server since that is covered in detail in the TechNet article below
If you do pick your own name make sure SQL Server name does not contain more than 15 characters Notice I also changed the Instance root folder to my E drive Once making any changes you like, just click Next On the Disk Space Requirements Screen just click Next The next screen is the Server Configuration. After you open the port and before you confirm whether remote users can access the report server on the port that you open, you must grant user access to the report server through role assignments on Home and at the site level
Faster insights on any data Get to insights faster with a complete BI platform that speeds up how you access, analyze, clean and shape both internal and external data. Back to top SQL Server 2014 in the news Gartner Read Gartner's Magic Quadrant for Advanced Analytics Platforms Read the story Gartner Read Gartner's Magic Quadrant for Business Intelligence and Analytics Platforms Read the story Gartner Read Gartner's Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics 2015 Read the story TechRadar.pro Microsoft SQL Server 2014 review: The database heads into memory for Microsoft's latest release Read the review Back to top SQL Server blog Announcing Spark for Azure HDInsight public preview 10 Jul 2015 04:10 PM by T.K
Since I am able to bring in one record at a time, is it possible to create a sql user function to pull in multiple records for say, an SSRS report? Reply 4-18-14 Sri says: Enjoy.. We manage our SSRS folder permissions using AD and it would be a huge benefit to be able to query AD to get a list of who has permissions to folders and reports on our SSRS
The only way to tell is to stress test your application while varying the type of VM, the amount of concurrency in each VM, and other factors that can influence your design (e.g., how much batching to perform, etc). This along with concurrency is a great option to upload large number of entities since you get high throughput and batches are cost efficient since you pay for each batch request and not the individual entities
windows - How do I get SQL Server to release its memory? - Server Fault
But if all the memory is used by the buffer pool, then evicting the entire buffer pool will result in tremendous performance degradation and huge IO load. You could probably write something which hits the win32 API directly to do so, but as far as I know the only way to trigger Windows to request memory back is to cause it to need more memory for another process
Facebook Microsoft OLE DB provider for SQL Server error 80004005 BY Mahesh Gupta on August 10, 2012 0 comments While browsing a ASP site, you end up getting SQL Server error 80004005. Thus by End of 1st year, our database size is expected to be 13 GB (1 Gb initial and 1 GB per month) After a year company is expected to come up with big launch and will advertise in market and expected 5 time growth in second year i.e
How to Get Week Day Name using T-SQL in MS SQL Server
Here, you can find below a T-SQL user-defined function which returns the week day of a date send as parameter to the user defined function taking into consideration of @@DateFirst server parameter. Since I used to work on SQL Servers distributed on different parts of the World, the @@DateFirst parameter could be set different among database servers
How to combine date from one field with time from another field - MS SQL Server - Stack Overflow
Luckily, in this case I can guarantee other items are always zero, I think the 2 fields may even be 1 on the other side the 3rd party code which does the extract for us. if the Time part of your Date column is always zero and the Date part of your Time column is also always zero (base date: January 1, 1900) Adding them returns the correct result
sql server - How to get a date in YYYY-MM-DD format from a TSQL datetime field? - Stack Overflow
Is there a simple way to perform this in SQL Server or would it be easier to convert it programatically after I retrieve the result set? I've read the CAST and CONVERT on Microsoft Technet, but the format I want isn't listed and changing the date format isn't an option
No comments:
Post a Comment