Eitan Blumin presents a little known method for executing stored procedures with a dynamic name while still protecting from SQL Injection.
http://www.madeira.co.il/dynamic-stored-procedure-execution-in-sql-server/
Here's Eitan Blumin's cool sample of how you can use Service Broker to your benefit by implementing multi-threading in SQL Server.
http://www.madeira.co.il/service-broker-sample-multi-threading/
If you love SQL Server 2012, if you already know a thing or two about it and you want to learn more, this is for you!
http://www.madeira.co.il/sql-server-2012-team-vs-100/
Madeira is celebrating 5 years and the best way to party was a 2 days, better-than-ever, company trip.
http://www.madeira.co.il/madeira-is-celebrating-5-years/
Get ready for the biggest SQL Server event of the year!
http://www.madeira.co.il/sql-explore-2/
כל רשומה בטבלה שמורה במקום פיזי כלשהו. המיקום הפיזי של הרשומה מורכב מ-3 דברים: הקובץ הפיזי בו היא מצוייה, המספר פייג' אליו היא משוייכת ובאיזה מיקום בתוך אותו הפייג'. על זה ועוד בפוסט המרתק של חיים פישנר.
http://www.madeira.co.il/%d7%9e%d7%99%d7%a7%d7%95%d7%9e%d7%94-%d7%94%d7%a4%d7%99%d7%96%d7%99-%d7%a9%d7%9c-%d7%a8%d7%a9%d7%95%d7%9e%d7%94-%d7%91%d7%98%d7%91%d7%9c%d7%94/
How simple are subqueries, or better said – how simple is understanding them? Let’s see what Dudi Rosenthal has to say about that.
http://www.madeira.co.il/subqueries-for-beginners-3/
Ranking functions returns a ranking value for each row either in a partition, or not. We can produce the very same result for all functions, but they have different purpose. Let Asaf Aviv explain you all about it.
http://www.madeira.co.il/difference-between-row_number-rank-dense_rank-ntile/
כפי שאנחנו כבר יודעים, המידע שלנו שמור ביחידות שנקראות פייג'ים, או דפים. כל דף יכול להכיל עד 8 קילובייט של נתונים.
האם באמת הדבר נכון?
אז לא!
תנו לחיים פישנר להסביר לכם מדוע.
http://www.madeira.co.il/%d7%94%d7%99%d7%9b%d7%9f-%d7%94%d7%a8%d7%a9%d7%95%d7%9e%d7%95%d7%aa-%d7%a9%d7%9c%d7%99/
Spatial data is defined as data that is represented by 2D or 3D images. Lets take a look at this interesting, valuable tool in SQL Server 2008 in a post by Dudi Rosenthal:
http://www.madeira.co.il/spatial-data/
DateTime2 is the new Data Type introduced in SQL Server 2008 for storing Date and Time value. Read what Chico Drori has to tell you about it:
http://www.madeira.co.il/sql-server-datetime-vs-datetime2/
Shay Attiya loves foreign keys and he just can't wait to tell you why!
http://www.madeira.co.il/foreign-keys-and-how-they-help-the-optimizer/
More Posts
Next page »