Viewing 15 posts - 2,101 through 2,115 (of 6,041 total)
Now that we have SQL Server running on Windows Core and Linux, some of you old-school DBAs will have to get acquainted with command line tools. 🙂
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 1, 2016 at 7:54 am
You have to choose to right tool for the job. Counting vehicles as they pass under a bridge on an eight lane interstate highway is very different than counting financial...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 1, 2016 at 7:44 am
Did they mention anything about SSIS being ported to Azure PaaS ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 31, 2016 at 2:29 pm
Gary Varga (10/31/2016)
Eric M Russell (10/31/2016)
Forget about Zombies and Killer Clowns, it's far more likely your database server will be subjected to attacks from IoT enabled refrigerators and toilets.
I could...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 31, 2016 at 11:03 am
In most shops, trying to argue with application developers on the issue of proper database modeling and SQL coding is a lost cause. You'll just end up earning a reputation...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 31, 2016 at 9:39 am
OLAP tools like SSAS are excellent for specific types of data access patterns and are an order of magnitude better at solving these problems than relational and no-sql database platforms....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 31, 2016 at 8:47 am
Forget about Zombies and Killer Clowns, it's far more likely your database server will be subjected to attacks from IoT enabled refrigerators and toilets.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 31, 2016 at 8:18 am
Eric M Russell (10/4/2016)
Gary Varga (10/4/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 31, 2016 at 8:04 am
... he tells me well, that his database via Entity Framework by default just creates all strings as nvarchar(max).
You plenty of reasons to be concerned at this point with this...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2016 at 9:27 am
Suth (10/28/2016)
indicies ? do you mean indexes ?
It seems to me that the columns [odid] needs to be indexed; otherwise it's going to do a table scan for each batch....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 28, 2016 at 9:16 am
The buffer cache contains data and index pages. For example, logical reads are from buffer cache while physical reads are from disk.
The procedure cache contains query execution plans.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2016 at 11:10 am
All indexes suggested by DTA are useful within the context of sample query that was supplied to DTA. The problem is that often times these index suggestions are for niche...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2016 at 11:01 am
S_Kumar_S (10/27/2016)
like only a sysadmin can create a linked server....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2016 at 10:44 am
Zomies?! Orcs?! Haven't you guys got better things to do with your time than sit in the server room playing Dungeons & Dragons?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2016 at 9:45 am
By default, a user is in the PUBLIC role and cannot do anything. You then should grant them permissions piecemeal. There are probably 1,000 things a member of SYSADMIN can...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2016 at 9:25 am
Viewing 15 posts - 2,101 through 2,115 (of 6,041 total)