sqldude.wordpress.com
Sqldude's Blog | A random Collection of SQLA random Collection of SQL
http://sqldude.wordpress.com/
A random Collection of SQL
http://sqldude.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.4 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
8
SSL
EXTERNAL LINKS
1
SITE IP
192.0.78.13
LOAD TIME
0.406 sec
SCORE
6.2
Sqldude's Blog | A random Collection of SQL | sqldude.wordpress.com Reviews
https://sqldude.wordpress.com
A random Collection of SQL
sqldude.wordpress.com
Sqldude's Blog | A random Collection of SQL | Page 2
https://sqldude.wordpress.com/page/2
A random Collection of SQL. Stored procedure modification date. June 3, 2009. Many times we need to find what procedures were updated or modified in last hour or day or a week. In SQL server 2000, sysobjects only saved the creation date. This info was not available back then. Sql server 2005 has included new catalog view sys.procedures which has create date as well as modify date. The column modify date carries the date when the procedure was modified. SELECT name,create date,modify date. March 21, 2009.
Month name from month number | Sqldude's Blog
https://sqldude.wordpress.com/2010/12/13/50
A random Collection of SQL. Month name from month number. December 13, 2010. At times, we have to get the month name and all that we have is a month number, here is a quick smart way to get the name of the month corresponding to the month number:. SET @month = 4. SELECT DateName(mm,DATEADD(mm,@month,-1) Month. To get the list of all the months spelled our along with their corresponding month numbers:. SELECT Number 1 as [Month Number],. DateName(mm,DATEADD(mm,Number,0) as [Month Name]. From → Scripts.
Sqldude's Blog
https://sqldude.wordpress.com/2010/08/18/44
A random Collection of SQL. August 18, 2010. List tables with Identity Insert on off. Has Identity nvarchar(max),. SET @sql = ‘select objectproperty(object ID(”? 8221;) ,”TableHasIdentity”),”? SELECT CASE Has Identity WHEN 0 THEN ‘NO’ WHEN 1 THEN ‘YES’ END AS Has Idenity, Table Name. From → Scripts. Larr; Date time in sql 2008. Month name from month number →. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). Blog at Wo...
A day at work | Sqldude's Blog
https://sqldude.wordpress.com/2009/09/17/a-day-at-work
A random Collection of SQL. A day at work. September 17, 2009. At one of the clients, a sql server express box had crashed. Before the crash, sql server express was previously installed on that box, the IT dept took insanely long time to fix the machine and after they got the machine back, sql server service could not start. Was getting following error:. Which meant that the Model database log file was either corrupt or was inconsistent. But when I tried to start sql server using start. But time was of e...
Predict table size | Sqldude's Blog
https://sqldude.wordpress.com/2009/08/24/predict-table-size
A random Collection of SQL. August 24, 2009. Find the size of one row : 4 30 30 50 15 2 10 = 141 bytes. We always calculate the max size of the row in the table. Find the number of rows that will fit on a single page:. Remember the size of the page is 8096 bytes (without the page header size). So; size of page / size of one row =. Number of rows that fit on one page. 8096/ 141 = 57.4184. Round it down to 57 as we have to contain every row in one page. This is our number of pages : 17544. Leave one →.
TOTAL PAGES IN THIS WEBSITE
8
SQL DSL
SQLDTS.com - Data Transformation Services on the web
The Rational Guide to Extending SSIS 2005 with Script. Data Transformation Services on the web. Welcome to SQLDTS.com, the Data Transformation Services (DTS) resource on the web. Hopefully there is something here for all levels of DTS user including you. Featured article: DTS Backup 2000. Most popular articles this month. Global Variables and Stored Procedure Parameters. Working with files and the FileSystemObject. Getting Syntax Help for DTSRun. Redistributing DTS with your program. Connections are wher...
SQL Tips & Tricks
SQL Tips and Tricks. Its all about structured query language (SQL) - SQL Query Snippets, LINQ Snippets, SQL Stored Procedures, SQL Server Articles, SQL Server Feeds, SQL Server Analytics, SQL Server Integration Services (SSIS), Microsoft SQL Server BIG DATA - HortonWorks, SQL Server CRM Integration. C# / VB.NET Tips and Tricks. Tuesday, May 14, 2013. How to Perform Analysis with SQL Server Analysis Services Project (Step by Step Instruction). Select the Generate tables option. Time dimension is created a...
Sqldude's Blog | A random Collection of SQL
A random Collection of SQL. Month name from month number. December 13, 2010. At times, we have to get the month name and all that we have is a month number, here is a quick smart way to get the name of the month corresponding to the month number:. SET @month = 4. SELECT DateName(mm,DATEADD(mm,@month,-1) Month. To get the list of all the months spelled our along with their corresponding month numbers:. SELECT Number 1 as [Month Number],. DateName(mm,DATEADD(mm,Number,0) as [Month Name]. From → Scripts.
SQL Dumbass
Fighting dumbasses, one query at a time…. This is the top bar widget. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis quis ipsum magna, sit amet ultricies nulla. Phasellus justo neque, interdum sed porta tempus, dapibus eu augue. Curabitur quis dolor ac nunc accumsan ultricies. Praesent et diam orci, id tincidunt massa. Nunc ut tortor turpis. Share the Love, Dumbass! September 6th, 2011. Enjoy and have fun, and don’t make it personal (or offensive) or you will find yourself banned. July 20t...
Welcome my SQL Dump - Marcus' SQL Dump
Oracle queries and stuff that I need frequently. Perf, Traceing, Auditing. Hint for a good optimizer index cost adj value. Deleteing failed datapump jobs. Query PGA/UGA sizes by SID. Last analyzed - Statistics. PROCESSES Parameter to low? Converting Date to TIMESTAMP TZ. Size PGA and SGA. It seems you have no tags attached to pages. To attach a tag simply click on the. Button at the bottom of any page. Add a new page. Welcome my SQL Dump. Use the navigation bar on top to get to the real content. Notify a...
sqldumps.com - Registered at Namecheap.com
This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! This domain is registered at Namecheap. This domain was recently registered at Namecheap. Please check back later! The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.
SQL Database Resources & Data Base Dumps for MySQL, CSV, Access & Oracle
Food and Drink databases. Welcome Guest, please login. Welcome to SQL Dumpster. Hello We provide databases in ready to use formats including CSV and SQL database dumps. We provide databases for website designers. Software developers, direct marketing and market research. We supply website content. Marketing lead databases, directory data for location based services and other business listings. Range from postcode data. To football player databases. And everything in between! Car makes and models.
SQL with Dustin Ryan | Dustin Ryan is an MSBI consultant, trainer, speaker & author specializing in data warehousing, SSAS, SSIS, SSRS, Power BI and SharePoint
SQL with Dustin Ryan. Here’s the New #Excel 2016 Chart Types! Power BI Desktop Designer. PowerBI Tip: Use the Treemap, Column or Funnel Chart as a Colorful Slicer. Power BI Desktop Designer. Three Best Practices for #PowerBI. MDXMonday: Previous Year Month to Date Calculation. Power BI Desktop Designer. Power BI Desktop: My First Run Through. 3 SSAS Dimension Design Best Practices to Live By. Refreshing Excel Power Query and Pivot Tables with SSIS and Task Factory. August 14, 2015. Once you create your c...
SOCIAL ENGAGEMENT